app_competency_modulecomp

0 rows


Description

Link a competency to a module.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_competency_modulecomp_id_seq'::regclass)
cmid int8 19 null
app_course_modules.id Defined in XMLR
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null
sortorder int8 19 null
competencyid int8 19 null
app_competency.id Defined in XMLR
ruleoutcome int2 5 null

Indexes

Constraint Name Type Sort Column(s)
app_compmodu_id_pk Primary key Asc id
app_compmodu_cmi_ix Performance Asc cmid
app_compmodu_cmicom_uix Must be unique Asc/Asc cmid + competencyid
app_compmodu_cmirul_ix Performance Asc/Asc cmid + ruleoutcome
app_compmodu_com_ix Performance Asc competencyid

Relationships