app_course_completions

0 rows


Description

Course completion records

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_course_completions_id_seq'::regclass)
userid int8 19 0
course int8 19 0
deleted int2 5 null
timenotified int8 19 null
timeenrolled int8 19 0
timestarted int8 19 0
timecompleted int8 19 null
reaggregate int8 19 0
status int2 5 0
rpl varchar 255 null
organisationid int8 19 null
positionid int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_courcomp_id_pk Primary key Asc id
app_courcomp_cou_ix Performance Asc course
app_courcomp_tim_ix Performance Asc timecompleted
app_courcomp_use_ix Performance Asc userid
app_courcomp_usecou_uix Must be unique Asc/Asc userid + course

Diagram producer might be missing

No diagrams were produced please see application output for any errors