grade_outcomes_courses

0 rows


Description

stores what outcomes are used in what courses.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
courseid BIGINT 19 null
course.id gradoutccour_cou2_fkR

id of the course
outcomeid BIGINT 19 null
grade_outcomes.id gradoutccour_out2_fkR

id of the outcome

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradoutccour_cou2_ix Performance Asc courseid
gradoutccour_couout2_uix Must be unique Asc/Asc courseid + outcomeid
gradoutccour_out2_ix Performance Asc outcomeid

Relationships

Close relationships within degrees of separation