Prog Completion Table Schema (prog_completion)


Stores details of user's program and course set completions

prog_completion table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
programid BIGINT 19 0 progcomp_pro3_fk R
userid BIGINT 19 0 progcomp_use3_fk R
coursesetid BIGINT 19 0 progcomp_cou3_fk R
status SMALLINT 5 0
timestarted BIGINT 19 0
timecreated BIGINT 19 0
timedue BIGINT 19 0
timecompleted BIGINT 19 0
organisationid BIGINT 19 null Implied Constraint R
positionid BIGINT 19 null Implied Constraint R

Table contained -1 rows

prog_completion table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progcomp_cou2_ix Performance Asc coursesetid
progcomp_cou_ix Performance Asc coursesetid
progcomp_pro2_ix Performance Asc programid
progcomp_pro_ix Performance Asc programid
progcomp_prousecou_uix Must be unique Asc/Asc/Asc programid + userid + coursesetid
progcomp_use2_ix Performance Asc userid
progcomp_use_ix Performance Asc userid

prog_completion table relationships