Prog Courseset Course Table Schema (prog_courseset_course)


Description

Stores the details of the individual courses contained in a course set

prog_courseset_course table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
coursesetid BIGINT 19 0
prog_courseset.id progcourcour_cou5_fk R
courseid BIGINT 19 0
course.id progcourcour_cou6_fk R

Table contained -1 rows

prog_courseset_course table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progcourcour_cou2_ix Performance Asc courseid
progcourcour_cou3_ix Performance Asc coursesetid
progcourcour_cou4_ix Performance Asc courseid
progcourcour_cou_ix Performance Asc coursesetid

prog_courseset_course table relationships

Close relationships within degrees of separation