std_plan_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
std_subplan_history.uw_id std_subplan_history_uw_id_fkeyR
std_program_history.uw_id std_plan_history_uw_id_fkeyR
career_code "_quest"."quest_career" 2147483647 null
std_subplan_history.career_code std_subplan_history_uw_id_fkeyR
std_program_history.career_code std_plan_history_uw_id_fkeyR
career_num int4 10 null
std_subplan_history.career_num std_subplan_history_uw_id_fkeyR
std_program_history.career_num std_plan_history_uw_id_fkeyR
program_as_of date 13 null
std_subplan_history.program_as_of std_subplan_history_uw_id_fkeyR
std_program_history.program_as_of std_plan_history_uw_id_fkeyR
program_sequence int4 10 null
std_subplan_history.program_sequence std_subplan_history_uw_id_fkeyR
std_program_history.program_sequence std_plan_history_uw_id_fkeyR
plan_code text 2147483647 null
std_subplan_history.plan_code std_subplan_history_uw_id_fkeyR
plan_order int4 10 null
requirement_term_id "_quest"."quest_term_id" 2147483647 √ null
uw_term.term_id Implied ConstraintR
degree_id "_quest"."quest_degree_id" 2147483647 √ null

Table contained 1462611 rows

Indexes

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

Relationships

Close relationships within degrees of separation