std_degree_plan


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
std_degree_subplan.uw_id std_degree_subplan_uw_id_fkeyR
std_degree.uw_id std_degree_plan_uw_id_fkeyR
degree_id "_quest"."quest_degree_id" 2147483647 null
std_degree_subplan.degree_id std_degree_subplan_uw_id_fkeyR
std_degree.degree_id std_degree_plan_uw_id_fkeyR
plan_code text 2147483647 null
std_degree_subplan.plan_code std_degree_subplan_uw_id_fkeyR
pps_plan.plan_code std_degree_plan_plan_code_fkeyR
plan_order int4 10 null

Table contained 144043 rows

Indexes

Constraint Name Type Sort Column(s)
std_degree_plan_pkey Primary key Asc/Asc/Asc uw_id + degree_id + plan_code
std_degree_plan_uw_id_degree_id_plan_order_key Must be unique Asc/Asc/Asc uw_id + degree_id + plan_order

Relationships

Close relationships within degrees of separation