Prog Courseset Table Schema (prog_courseset)


Description

Stores details of the sets of courses and competencies contained within a program

prog_courseset table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
prog_completion.coursesetid progcomp_cou3_fk R
prog_completion_history.coursesetid progcomphist_cou3_fk R
prog_courseset_course.coursesetid progcourcour_cou5_fk R
prog_messagelog.coursesetid progmess_cou3_fk R
programid BIGINT 19 0
prog.id progcour_pro3_fk R
sortorder BIGINT 19 0
competencyid BIGINT 19 0
nextsetoperator SMALLINT 5 0
completiontype SMALLINT 5 0
mincourses SMALLINT 5 0
coursesumfield BIGINT 19 0
course_info_field.id progcour_cou2_fk R
coursesumfieldtotal SMALLINT 5 0
timeallowed BIGINT 19 0
recurrencetime BIGINT 19 0
recurcreatetime BIGINT 19 0
contenttype SMALLINT 5 0
label VARCHAR 255 √
certifpath TINYINT 3 √ 1

1=standard program path or certify path, 2=recertify path

Table contained -1 rows

prog_courseset table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progcour_cou_ix Performance Asc coursesumfield
progcour_pro2_ix Performance Asc programid
progcour_pro_ix Performance Asc programid

prog_courseset table relationships

Close relationships within degrees of separation