app_dp_plan

0 rows


Description

Stores individual plans belonging to users.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_dp_plan_id_seq'::regclass)
app_dp_plan_competency_assign.planid Defined in XMLR
app_dp_plan_course_assign.planid Defined in XMLR
app_dp_plan_evidence_relation.planid Defined in XMLR
app_dp_plan_history.planid Defined in XMLR
app_dp_plan_objective.planid Defined in XMLR
app_dp_plan_program_assign.planid Defined in XMLR
templateid int8 19 null
app_dp_template.id Defined in XMLR
userid int8 19 null
app_user.id Defined in XMLR
name varchar 255 √ null
description text 2147483647 √ null
startdate int8 19 √ null
enddate int8 19 √ null
timecompleted int8 19 √ null
status int2 5 null
createdby int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_dpplan_id_pk Primary key Asc id
app_dpplan_tem_ix Performance Asc templateid
app_dpplan_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation