Dp Course Settings Table Schema (dp_course_settings)


Contains settings specific to the course component

dp_course_settings table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
templateid BIGINT 19 null

Identifies the template these settings should be applied to

duedatemode SMALLINT 5 0

Defines how due dates are handled by this component

prioritymode SMALLINT 5 0

Defines how priorities are handled within this component

priorityscale BIGINT 19 null
dp_priority_scale.id dpcoursett_pri2_fk R

Identifies the scale used by this component

Table contained -1 rows

dp_course_settings table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpcoursett_pri_ix Performance Asc priorityscale
dpcoursett_tem_uix Must be unique Asc templateid

dp_course_settings table relationships