Grade Outcomes Courses Table Schema (grade_outcomes_courses)


Description

stores what outcomes are used in what courses.

grade_outcomes_courses table columns

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

id of the course
outcomeid BIGINT 19 null
grade_outcomes.id gradoutccour_out2_fk R

id of the outcome

Table contained -1 rows

grade_outcomes_courses table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradoutccour_cou_ix Performance Asc courseid
gradoutccour_couout_uix Must be unique Asc/Asc courseid + outcomeid
gradoutccour_out_ix Performance Asc outcomeid

grade_outcomes_courses table relationships

Close relationships within degrees of separation