SchemaSpy - Table odyssey_test._quest.std_subplan_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_plan_history.uw_id

std_subplan_history_uw_id_fkey R

career_code

quest_career

2147483647

std_plan_history.career_code

std_subplan_history_uw_id_fkey R

career_num

int4

10

std_plan_history.career_num

std_subplan_history_uw_id_fkey R

program_as_of

date

13

std_plan_history.program_as_of

std_subplan_history_uw_id_fkey R

program_sequence

int4

10

std_plan_history.program_sequence

std_subplan_history_uw_id_fkey R

plan_code

text

2147483647

std_plan_history.plan_code

std_subplan_history_uw_id_fkey R

subplan_code

text

2147483647

requirement_term_id

quest_term_id

2147483647

Table contained 63,466 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 + subplan_code	Primary key	Asc/Asc/Asc/Asc/Asc/Asc/Asc	std_subplan_history_pkey