0 rows


Stores the completion state (completed or not completed, etc) of each user on each activity.


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
coursemoduleid BIGINT 19 null course_modules_completion_erd_course_modulesR

Activity that has been completed (or not).

userid BIGINT 19 null

ID of user who has (or hasn’t) completed the activity.

completionstate BIT 1 null

Whether or not the user has completed the activity. Available states: 0 = not completed if there’s no row in this table, that also counts as 0 1 = completed 2 = completed, show passed 3 = completed, show failed

overrideby BIGINT 19 null

Tracks whether this completion state has been set manually to override a previous state.

timemodified BIGINT 19 null

Time at which the completion state last changed.


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courmoducomp_cou_ix Performance Asc coursemoduleid
courmoducomp_usecou_uix Must be unique Asc/Asc userid + coursemoduleid