SchemaSpy - Table odyssey_test._quest.std_plan_history

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

uw_id

quest_uw_id

2147483647

std_subplan_history.uw_id

std_subplan_history_uw_id_fkey R

std_program_history.uw_id

std_plan_history_uw_id_fkey R

career_code

quest_career

2147483647

std_subplan_history.career_code

std_subplan_history_uw_id_fkey R

std_program_history.career_code

std_plan_history_uw_id_fkey R

career_num

int4

10

std_subplan_history.career_num

std_subplan_history_uw_id_fkey R

std_program_history.career_num

std_plan_history_uw_id_fkey R

program_as_of

date

13

std_subplan_history.program_as_of

std_subplan_history_uw_id_fkey R

std_program_history.program_as_of

std_plan_history_uw_id_fkey R

program_sequence

int4

10

std_subplan_history.program_sequence

std_subplan_history_uw_id_fkey R

std_program_history.program_sequence

std_plan_history_uw_id_fkey R

plan_code

text

2147483647

std_subplan_history.plan_code

std_subplan_history_uw_id_fkey R

pps_plan.plan_code

Implied Constraint R

plan_position

int4

10

requirement_term_id

quest_term_id

2147483647

√

null

degree_id

quest_degree_id

2147483647

√

null

Table contained 954,831 rows at Wed Feb 19 10:30 EST 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
uw_id + career_code + career_num + program_as_of + program_sequence + plan_code	Primary key	Asc/Asc/Asc/Asc/Asc/Asc	std_plan_history_pkey