Competency Modulecomp Table Schema (competency_modulecomp)


Description

Link a competency to a module.

competency_modulecomp table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
cmid bigint 10 null
course_modules.id compmodu_cmi2_fk R

ID of the record in the course_modules table.

timecreated bigint 10 null

The time this record was created.

timemodified bigint 10 null

The time this record was last modified

usermodified bigint 10 null

The user who last modified this field.

sortorder bigint 10 null

The field used to naturally sort this link.

competencyid bigint 10 null
competency.id compmodu_com2_fk R

The course competency this activity is linked to.

ruleoutcome tinyint 2 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