Prog Completion History Table Schema (prog_completion_history)


Description

Stores details of user's program and course set completions history

prog_completion_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
programid BIGINT 19 0
prog.id progcomphist_pro3_fk R
userid BIGINT 19 0
user.id progcomphist_use3_fk R
coursesetid BIGINT 19 0
prog_courseset.id progcomphist_cou3_fk R
status SMALLINT 5 0
timestarted BIGINT 19 0
timedue BIGINT 19 0
timecompleted BIGINT 19 0
recurringcourseid BIGINT 19 0
course.id progcomphist_rec3_fk R
organisationid BIGINT 19 √ null
org.id Implied Constraint R
positionid BIGINT 19 √ null
pos.id Implied Constraint R

Table contained -1 rows

prog_completion_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progcomphist_cou2_ix Performance Asc coursesetid
progcomphist_cou_ix Performance Asc coursesetid
progcomphist_pro2_ix Performance Asc programid
progcomphist_pro_ix Performance Asc programid
progcomphist_rec2_ix Performance Asc recurringcourseid
progcomphist_rec_ix Performance Asc recurringcourseid
progcomphist_use2_ix Performance Asc userid
progcomphist_use_ix Performance Asc userid

prog_completion_history table relationships

Close relationships within degrees of separation