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 0 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