adm_appl_subplan


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
adm_appl_plan.uw_id adm_appl_subplan_uw_id_fkeyR
appl_id "_quest"."quest_appl_id" 2147483647 null
adm_appl_plan.appl_id adm_appl_subplan_uw_id_fkeyR
program_order int4 10 null
adm_appl_plan.program_order adm_appl_subplan_uw_id_fkeyR
program_as_of date 13 null
adm_appl_plan.program_as_of adm_appl_subplan_uw_id_fkeyR
program_sequence int4 10 null
adm_appl_plan.program_sequence adm_appl_subplan_uw_id_fkeyR
plan_code text 2147483647 null
adm_appl_plan.plan_code adm_appl_subplan_uw_id_fkeyR
pps_subplan.plan_code adm_appl_subplan_plan_code_fkeyR
subplan_code text 2147483647 null
pps_subplan.subplan_code adm_appl_subplan_plan_code_fkeyR

Table contained 228702 rows

Indexes

Constraint Name Type Sort Column(s)
adm_appl_subplan_pkey Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc uw_id + appl_id + program_order + program_as_of + program_sequence + plan_code + subplan_code

Relationships

Close relationships within degrees of separation