Course Completion Log Table Schema (course_completion_log)


Description

Record of changes made to course completion records

course_completion_log table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
courseid BIGINT 19 null
course.id courcomplog_cou2_fk R

Course ID

userid BIGINT 19 null
user.id courcomplog_use2_fk R

Users id

changeuserid BIGINT 19 null
user.id courcomplog_cha2_fk R

User id of the person who caused the change

description LONGTEXT 2147483647 null

Description of what changed, English only

timemodified BIGINT 19 null

Table contained -1 rows

course_completion_log table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courcomplog_cha_ix Performance Asc changeuserid
courcomplog_cou_ix Performance Asc courseid
courcomplog_use_ix Performance Asc userid

course_completion_log table relationships