Dp Plan Table Schema (dp_plan)


Description

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

Close relationships within degrees of separation