pps_plan_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
plan_code text 2147483647 null
pps_plan.plan_code pps_plan_plan_code_fkeyR
plan_as_of date 13 null
pps_plan.plan_as_of pps_plan_plan_code_fkeyR
plan_active bool 1 null
plan_title text 2147483647 null
plan_short_title text 2147483647 null
plan_comment text 2147483647 √ null
plan_diploma_description text 2147483647 √ null
plan_transcript_description text 2147483647 null
degree_code text 2147483647 √ null
pps_degree.degree_code pps_plan_history_degree_code_fkeyR
program_code text 2147483647 √ null
pps_program.program_code pps_plan_history_program_code_fkeyR
career_code "_quest"."quest_career" 2147483647 √ null
unit_code text 2147483647 null
uw_unit.unit_code pps_plan_history_unit_code_fkeyR
plan_type_code text 2147483647 null
pps_plan_type.plan_type_code pps_plan_history_plan_type_code_fkeyR
first_valid_term_id "_quest"."quest_term_id" 2147483647 √ null
uw_term.term_id pps_plan_history_first_valid_term_id_fkeyR
last_admit_term_id "_quest"."quest_term_id" 2147483647 √ null
uw_term.term_id pps_plan_history_last_admit_term_id_fkeyR

Table contained 4246 rows

Indexes

Constraint Name Type Sort Column(s)
pps_plan_history_pkey Primary key Asc/Asc plan_code + plan_as_of

Relationships

Close relationships within degrees of separation