Dp Competency Settings Table Schema (dp_competency_settings)


Contains settings specific to the competency component

dp_competency_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

autoassignorg SMALLINT 5 0
autoassignpos SMALLINT 5 0
includecompleted SMALLINT 5 1
autoassigncourses SMALLINT 5 0

Flag to determine if linked courses should also be added when competencies are auto assigned

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 dpcompsett_pri2_fk R

Identifies the scale used by this component

autoadddefaultevidence SMALLINT 5 0

Table contained -1 rows

dp_competency_settings table indexes

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

dp_competency_settings table relationships