std_term_plan


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
std_term_subplan.uw_id std_term_subplan_uw_id_fkeyR
std_term_program.uw_id std_term_plan_uw_id_fkeyR
term_id "_quest"."quest_term_id" 2147483647 null
std_term_subplan.term_id std_term_subplan_uw_id_fkeyR
std_term_program.term_id std_term_plan_uw_id_fkeyR
plan_code text 2147483647 null
std_term_subplan.plan_code std_term_subplan_uw_id_fkeyR
pps_plan.plan_code std_term_plan_plan_code_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 2348443 rows

Indexes

Constraint Name Type Sort Column(s)
std_term_plan_pkey Primary key Asc/Asc/Asc uw_id + term_id + plan_code
std_term_plan_uw_id_term_id_plan_order_key Must be unique Asc/Asc/Asc uw_id + term_id + plan_order

Relationships

Close relationships within degrees of separation