Course Completions Table Schema (course_completions)


Course completion records

course_completions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
dp_plan_course_assign.completionstatus dpplancourassi_com2_fk R
userid BIGINT 19 0 courcomp_use2_fk R
course BIGINT 19 0 courcomp_cou2_fk R
organisationid BIGINT 19 null Implied Constraint R

Totara organisation id from totara_hierarchy

positionid BIGINT 19 null Implied Constraint R

Totara position id from totara_hierarchy

timeenrolled BIGINT 19 0
timestarted BIGINT 19 0
timecompleted BIGINT 19 null
reaggregate BIGINT 19 0
rpl VARCHAR 255 null

Totara recognition of prior learning from totara_core

rplgrade DECIMAL 10,5 null

Totara recognition of prior learning grade from totara_core

invalidatecache BIT 1 0

Deprecated since Totara 10, please do not use

status TINYINT 3 0

Totara status from totara_core

renewalstatus TINYINT 3 0

Totara renewal status from totara_core

Table contained -1 rows

course_completions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courcomp_cou_ix Performance Asc course
courcomp_sta_ix Performance Asc status
courcomp_tim_ix Performance Asc timecompleted
courcomp_use_ix Performance Asc userid
courcomp_usecou_uix Must be unique Asc/Asc userid + course

course_completions table relationships