pps_subplan_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
plan_code text 2147483647 null
pps_subplan.plan_code pps_subplan_plan_code_fkeyR
pps_plan.plan_code pps_subplan_history_plan_code_fkeyR
subplan_code text 2147483647 null
pps_subplan.subplan_code pps_subplan_plan_code_fkeyR
subplan_as_of date 13 null
pps_subplan.subplan_as_of pps_subplan_plan_code_fkeyR
subplan_active bool 1 null
subplan_title text 2147483647 null
subplan_short_title text 2147483647 null
subplan_diploma_description text 2147483647 √ null
subplan_transcript_description text 2147483647 null
subplan_type "_quest"."quest_subplan_type" 2147483647 null
first_valid_term_id "_quest"."quest_term_id" 2147483647 √ null
uw_term.term_id pps_subplan_history_first_valid_term_id_fkeyR
last_admit_term_id "_quest"."quest_term_id" 2147483647 √ null
uw_term.term_id pps_subplan_history_last_admit_term_id_fkeyR

Table contained 3408 rows

Indexes

Constraint Name Type Sort Column(s)
pps_subplan_history_pkey Primary key Asc/Asc/Asc plan_code + subplan_code + subplan_as_of

Relationships

Close relationships within degrees of separation