app_dp_plan_program_assign

0 rows


Description

Stores program assigned to a particular plan

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_dp_plan_program_assign_id_seq'::regclass)
planid int8 19 null
programid int8 19 null
priority int8 19 null
duedate int8 19 null
approved int2 5 0
manual int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_dpplanprogassi_id_pk Primary key Asc id
app_dpplanprogassi_pla_ix Performance Asc planid
app_dpplanprogassi_plapro_uix Must be unique Asc/Asc planid + programid

Diagram producer might be missing

No diagrams were produced please see application output for any errors