Dp Plan Program Assign Table Schema (dp_plan_program_assign)


Description

Stores program assigned to a particular plan

dp_plan_program_assign table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
planid BIGINT 19 null
dp_plan.id dpplanprogassi_pla2_fk R

Identifies the plan this program is attached to
programid BIGINT 19 null
prog.id dpplanprogassi_pro2_fk R

Identifies the program being assigned
priority BIGINT 19 √ null
dp_priority_scale_value.id dpplanprogassi_pri2_fk R

Identifies the priority of this program within the current plan.
duedate BIGINT 19 √ null

Timestamp of the date this program is due to be completed.
approved SMALLINT 5 0

Indicates if the program has been accepted as part of a plan, or is awaiting approval.
reasonfordecision LONGTEXT 2147483647 √ null

The reason for approving/declining the request
manual BIT 1 0

Was this assignment made manually

Table contained -1 rows

dp_plan_program_assign table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpplanprogassi_pla_ix Performance Asc planid
dpplanprogassi_plapro_uix Must be unique Asc/Asc planid + programid
dpplanprogassi_pri_ix Performance Asc priority
dpplanprogassi_pro_ix Performance Asc programid

dp_plan_program_assign table relationships

Close relationships within degrees of separation