Dp Plan Table Schema (dp_plan)


Stores individual plans belonging to users.

dp_plan table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
dp_plan_competency_assign.planid dpplancompassi_pla2_fk R
dp_plan_course_assign.planid dpplancourassi_pla2_fk R
dp_plan_evidence_relation.planid dpplanevidrela_pla2_fk R
dp_plan_history.planid dpplanhist_pla2_fk R
dp_plan_objective.planid dpplanobje_pla2_fk R
dp_plan_program_assign.planid dpplanprogassi_pla2_fk R
templateid BIGINT 19 null
dp_template.id dpplan_tem2_fk R

Identifies the template used by this plan.

userid BIGINT 19 null
user.id dpplan_use2_fk R

ID of the user this plan is for

name VARCHAR 255 null

Name of this development plan

description LONGTEXT 2147483647 null

Description of this development plan

startdate BIGINT 19 null

Timestamp of the start date of this plan

enddate BIGINT 19 null

Timestamp of the end date of this plan

timecompleted BIGINT 19 null

Timestamp of the completed date plan

status SMALLINT 5 null

Integer code indicating the state of the plan

createdby BIT 1 0

Integer to identify if the plan has been create by an automatic process

Table contained -1 rows

dp_plan table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpplan_tem_ix Performance Asc templateid
dpplan_use_ix Performance Asc userid

dp_plan table relationships