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