Dp Template Table Schema (dp_template)


Description

Templates store configuration options for a group of plans.

dp_template table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
cohort_plan_history.templateid cohoplanhist_tem2_fk R
dp_component_settings.templateid dpcompsett_tem3_fk R
dp_objective_settings.templateid dpobjesett_tem2_fk R
dp_permissions.templateid dpperm_tem2_fk R
dp_plan.templateid dpplan_tem2_fk R
fullname VARCHAR 255 √ null

User readable name for this template
shortname VARCHAR 100 √ null

A shorter name for this template (optional)
startdate BIGINT 19 √ null

Timestamp for when plans based on this template start by default
enddate BIGINT 19 √ null

Timestamp for when plans based on this template end by default.
sortorder BIGINT 19 null

Field to determine the order of the templates when displayed together
visible SMALLINT 5 null

To allow templates to be hidden
workflow VARCHAR 255 √ null

Current workflow for this template
isdefault BIT 1 0

To indicate if this is the default template

Table contained -1 rows

dp_template table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

dp_template table relationships

Close relationships within degrees of separation