Course Completion Crit Compl Table Schema (course_completion_crit_compl)


Course completion user records

course_completion_crit_compl table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
userid bigint 10 0 courcomplcritcoml_use_fk R
course bigint 10 0 courcomplcritcoml_cou_fk R
criteriaid bigint 10 0 courcomplcritcoml_cri_fk R

Completion criteria this references

gradefinal decimal 10 null

The final grade for the course (included regardless of whether a passing grade was required)

unenroled bigint 10 null

Timestamp when the user was unenroled

timecompleted bigint 10 null

Table contained -1 rows

course_completion_crit_compl table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courcompcritcomp_cou_ix Performance Asc course
courcompcritcomp_cri_ix Performance Asc criteriaid
courcompcritcomp_tim_ix Performance Asc timecompleted
courcompcritcomp_use_ix Performance Asc userid
courcompcritcomp_usecoucri_uix Must be unique Asc/Asc/Asc userid + course + criteriaid

course_completion_crit_compl table relationships