app_course_modules_completion

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_course_modules_completion_id_seq'::regclass)
coursemoduleid int8 19 null
userid int8 19 null
completionstate int2 5 null
viewed int2 5 null
timemodified int8 19 null
timecompleted int8 19 null
reaggregate int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_courmoducomp_id_pk Primary key Asc id
app_courmoducomp_cou_ix Performance Asc coursemoduleid
app_courmoducomp_usecou_uix Must be unique Asc/Asc userid + coursemoduleid

Diagram producer might be missing

No diagrams were produced please see application output for any errors