Competency Modulecomp Table Schema (competency_modulecomp)


Link a competency to a module.

competency_modulecomp table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
cmid BIGINT 19 null compmodu_cmi2_fk R

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

The course competency this activity is linked to.

ruleoutcome TINYINT 3 null

The outcome when an activity is completed.

Table contained -1 rows

competency_modulecomp table 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

competency_modulecomp table relationships