app_dp_template

1 rows


Description

Templates store configuration options for a group of plans.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_dp_template_id_seq'::regclass)
app_cohort_plan_history.templateid Defined in XMLR
app_dp_competency_settings.templateid Defined in XMLR
app_dp_component_settings.templateid Defined in XMLR
app_dp_course_settings.templateid Defined in XMLR
app_dp_objective_settings.templateid Defined in XMLR
app_dp_permissions.templateid Defined in XMLR
app_dp_plan.templateid Defined in XMLR
app_dp_plan_settings.templateid Defined in XMLR
app_dp_program_settings.templateid Defined in XMLR
fullname varchar 255 √ null
shortname varchar 100 √ null
startdate int8 19 √ null
enddate int8 19 √ null
sortorder int8 19 null
visible int2 5 null
workflow varchar 255 √ null
isdefault int2 5 0

Indexes

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

Relationships

Close relationships within degrees of separation