grade_outcomes_modules

0 rows


Description

Associates scale-less outcomes with course modules.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
outcomecourseid BIGINT 19 null
grade_outcomes_courses.id gradoutcmodu_out2_fkR

Foreign key to grade_outcomes_courses.

cmid BIGINT 19 null
course_modules.id gradoutcmodu_cmi2_fkR

Foreign key to course_modules.

usercreated BIGINT 19 null
user.id gradoutcmodu_use2_fkR

User ID of the person who created this association.

timecreated BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradoutcmodu_cmi_ix Performance Asc cmid
gradoutcmodu_out_ix Performance Asc outcomecourseid
gradoutcmodu_outcmi_uix Must be unique Asc/Asc outcomecourseid + cmid
gradoutcmodu_use_ix Performance Asc usercreated

Relationships