course_modules_viewed

0 rows


Description

Tracks the completion viewed (viewed with cmid/userid and otherwise no row) of each user on each activity.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
coursemoduleid BIGINT 19 null
course.id Implied ConstraintR

Activity that has been viewed (or not).

userid BIGINT 19 null

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

timecreated BIGINT 19 null

Time at which the completion viewed created.

Indexes

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

Relationships