std_subplan_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
std_plan_history.uw_id std_subplan_history_uw_id_fkeyR
career_code "_quest"."quest_career" 2147483647 null
std_plan_history.career_code std_subplan_history_uw_id_fkeyR
career_num int4 10 null
std_plan_history.career_num std_subplan_history_uw_id_fkeyR
program_as_of date 13 null
std_plan_history.program_as_of std_subplan_history_uw_id_fkeyR
program_sequence int4 10 null
std_plan_history.program_sequence std_subplan_history_uw_id_fkeyR
plan_code text 2147483647 null
std_plan_history.plan_code std_subplan_history_uw_id_fkeyR
subplan_code text 2147483647 null
requirement_term_id "_quest"."quest_term_id" 2147483647 null
uw_term.term_id Implied ConstraintR

Table contained 90714 rows

Indexes

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

Relationships

Close relationships within degrees of separation