competency_modulecomp

0 rows


Description

Link a competency to a module.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
cmid BIGINT 19 null
course_modules.id compmodu_cmi2_fkR

ID of the record in the course_modules table.

timecreated BIGINT 19 null

The time this record was created.

timemodified BIGINT 19 null

The time this record was last modified

usermodified BIGINT 19 null
user.id compmodu_use2_fkR

The user who last modified this field.

sortorder BIGINT 19 null

The field used to naturally sort this link.

competencyid BIGINT 19 null
competency.id competency_modulecomp_erd_competencyR

The course competency this activity is linked to.

ruleoutcome TINYINT 3 null

The outcome when an activity is completed.

overridegrade BIT 1 0

Enables the ability to override an existing competencys grade.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compmodu_cmi_ix Performance Asc cmid
compmodu_cmicom_uix Must be unique Asc/Asc cmid + competencyid
compmodu_cmirul_ix Performance Asc/Asc cmid + ruleoutcome
compmodu_com_ix Performance Asc competencyid
compmodu_use_ix Performance Asc usermodified

Relationships