adm_appl_plan


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
adm_appl_subplan.uw_id adm_appl_subplan_uw_id_fkeyR
adm_appl_program_history.uw_id adm_appl_plan_uw_id_fkeyR
appl_id "_quest"."quest_appl_id" 2147483647 null
adm_appl_subplan.appl_id adm_appl_subplan_uw_id_fkeyR
adm_appl_program_history.appl_id adm_appl_plan_uw_id_fkeyR
program_order int4 10 null
adm_appl_subplan.program_order adm_appl_subplan_uw_id_fkeyR
adm_appl_program_history.program_order adm_appl_plan_uw_id_fkeyR
program_as_of date 13 null
adm_appl_subplan.program_as_of adm_appl_subplan_uw_id_fkeyR
adm_appl_program_history.program_as_of adm_appl_plan_uw_id_fkeyR
program_sequence int4 10 null
adm_appl_subplan.program_sequence adm_appl_subplan_uw_id_fkeyR
adm_appl_program_history.program_sequence adm_appl_plan_uw_id_fkeyR
plan_code text 2147483647 null
adm_appl_subplan.plan_code adm_appl_subplan_uw_id_fkeyR
pps_plan.plan_code adm_appl_plan_plan_code_fkeyR
plan_order int4 10 null

Table contained 2501139 rows

Indexes

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

Relationships

Close relationships within degrees of separation