app_prog_courseset_course

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_prog_courseset_course_id_seq'::regclass)
coursesetid int8 19 0
app_prog_courseset.id Defined in XMLR
courseid int8 19 0
app_course.id Defined in XMLR
sortorder int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_progcourcour_id_pk Primary key Asc id
app_progcourcour_cou2_ix Performance Asc courseid
app_progcourcour_cou_ix Performance Asc coursesetid

Relationships

Close relationships within degrees of separation