0 rows


Link a competency to a module.


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
cmid BIGINT 19 null 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

The user who last modified this field.

sortorder BIGINT 19 null

The field used to naturally sort this link.

competencyid BIGINT 19 null competency_modulecomp_erd_competencyR

The course competency this activity is linked to.

ruleoutcome TINYINT 3 null

The outcome when an activity is completed.


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compmodu_cmi2_ix Performance Asc cmid
compmodu_cmicom2_uix Must be unique Asc/Asc cmid + competencyid
compmodu_cmirul2_ix Performance Asc/Asc cmid + ruleoutcome
compmodu_com2_ix Performance Asc competencyid