pps_plan


Columns

Column Type Size Nulls Auto Default Children Parents Comments
plan_code text 2147483647 null
ta_plan_entitlement.plan_code ta_plan_entitlement_plan_code_fkeyR
ta_student_entitlement.plan_code ta_student_entitlement_plan_code_fkeyR
adm_appl_plan.plan_code adm_appl_plan_plan_code_fkeyR
pps_subplan_history.plan_code pps_subplan_history_plan_code_fkeyR
std_degree_plan.plan_code std_degree_plan_plan_code_fkeyR
std_grad_supervisor.plan_code std_grad_supervisor_plan_code_fkeyR
std_milestone.plan_code std_milestone_plan_code_fkeyR
std_term_plan.plan_code std_term_plan_plan_code_fkeyR
std_term_plan_gpa.plan_code std_term_plan_gpa_plan_code_fkeyR
std_term_plan_plus.plan_code Implied ConstraintR
std_transfer_credit_school.plan_code std_transfer_credit_school_plan_code_fkeyR
std_transfer_credit_school_plus.plan_code Implied ConstraintR
pps_plan_history.plan_code pps_plan_plan_code_fkeyR
plan_as_of date 13 null
pps_plan_history.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_degree_code_fkeyR
program_code text 2147483647 √ null
pps_program.program_code pps_plan_program_code_fkeyR
career_code "_quest"."quest_career" 2147483647 √ null
unit_code text 2147483647 null
uw_unit.unit_code pps_plan_unit_code_fkeyR
plan_type_code text 2147483647 null
pps_plan_type.plan_type_code pps_plan_plan_type_code_fkeyR
first_valid_term_id "_quest"."quest_term_id" 2147483647 √ null
uw_term.term_id pps_plan_first_valid_term_id_fkeyR
last_admit_term_id "_quest"."quest_term_id" 2147483647 √ null
uw_term.term_id pps_plan_last_admit_term_id_fkeyR

Table contained 2559 rows

Indexes

Constraint Name Type Sort Column(s)
pps_plan_pkey Primary key Asc plan_code

Relationships

Close relationships within degrees of separation