Course Completion History Table Schema (course_completion_history)


Description

Course completion history archive

course_completion_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
courseid BIGINT 19 null
course.id courcomphist_cou2_fk R
userid BIGINT 19 null
user.id courcomphist_use2_fk R
timecompleted BIGINT 19 √ null
grade DECIMAL 10,5 √ null

Table contained -1 rows

course_completion_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courcomphist_cou_ix Performance Asc courseid
courcomphist_use_ix Performance Asc userid

course_completion_history table relationships

Close relationships within degrees of separation