Course Completion Criteria Table Schema (course_completion_criteria)


Description

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 courcomplcritcoml_cri_fk R
course BIGINT 19 0
course.id courcompcrit_cou_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
course_modules.id courcompcrit_min_fk R

Module instance id (if using module criteria type)
courseinstance BIGINT 19 √ null
course.id courcompcrit_cin_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_cin_fk Performance Asc courseinstance
courcompcrit_cou_ix Performance Asc course
courcompcrit_min_fk Performance Asc moduleinstance

course_completion_criteria table relationships

Close relationships within degrees of separation