Course Completions Table Schema (course_completions)


Description

Course completion records

course_completions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
userid bigint 10 0
user.id courcompl_use_fk R
course bigint 10 0
course.id courcompl_cou_fk R
timeenrolled bigint 10 0
timestarted bigint 10 0
timecompleted bigint 10 √ null
reaggregate bigint 10 0

Table contained -1 rows

course_completions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courcomp_cou_ix Performance Asc course
courcomp_tim_ix Performance Asc timecompleted
courcomp_use_ix Performance Asc userid
courcomp_usecou_uix Must be unique Asc/Asc userid + course

course_completions table relationships

Close relationships within degrees of separation