Dp Plan Program Assign Table Schema (dp_plan_program_assign)


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