Course Completions table / course_completions - Moodle LMS 3.9 Database schema / Zoola Analytics

course_completions table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

userid

BIGINT

19

0

user.id

courcomp_use2_fk R

course

BIGINT

19

0

course.id

courcomp_cou2_fk R

timeenrolled

BIGINT

19

0

timestarted

BIGINT

19

0

timecompleted

BIGINT

19

√

null

reaggregate

BIGINT

19

0

Showing 1 to 7 of 7 entries

Table contained -1 rows

course_completions table indexes

Search:

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

Showing 1 to 5 of 5 entries

Course Completions Table Schema (course_completions)

Description

course_completions table columns

course_completions table indexes

course_completions table relationships

Close relationships within degrees of separation