Course Completion Criteria Table Schema (course_completion_criteria)


Course completion criteria

course_completion_criteria table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
course_completion_crit_compl.criteriaid courcompcritcomp_cri2_fk R
course BIGINT 19 0 courcompcrit_cou2_fk R
criteriatype BIGINT 19 0

Type of criteria

module VARCHAR 100 null

Type of module (if using module criteria type)

moduleinstance BIGINT 19 null courcompcrit_mod2_fk R

Module instance id (if using module criteria type)

courseinstance BIGINT 19 null courcompcrit_cou3_fk R

Course instance id (if using course criteria type)

enrolperiod BIGINT 19 null

Number of days after enrolment the course is completed (if using enrolperiod criteria type)

timeend BIGINT 19 null

Timestamp of the date for course completion (if using date criteria type)

gradepass DECIMAL 10,5 null

The minimum grade needed to pass the course (if passing grade criteria enabled)

role BIGINT 19 null

Table contained -1 rows

course_completion_criteria table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courcompcrit_cou3_fk Performance Asc courseinstance
courcompcrit_cou_ix Performance Asc course
courcompcrit_mod_ix Performance Asc moduleinstance

course_completion_criteria table relationships