Prog Recurrence Table Schema (prog_recurrence)


Description

Store the id numbers of the courses that will replace existing courses in a recurring program so that the system can know which course will be used when the current course ends

prog_recurrence table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
programid BIGINT 19 0
prog.id progrecu_pro3_fk R
currentcourseid BIGINT 19 0
course.id progrecu_cur3_fk R
nextcourseid BIGINT 19 0
course.id progrecu_nex3_fk R

Table contained -1 rows

prog_recurrence table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progrecu_cur2_ix Performance Asc currentcourseid
progrecu_cur_ix Performance Asc currentcourseid
progrecu_nex2_ix Performance Asc nextcourseid
progrecu_nex_ix Performance Asc nextcourseid
progrecu_pro2_ix Performance Asc programid
progrecu_pro_ix Performance Asc programid

prog_recurrence table relationships

Close relationships within degrees of separation