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 10 null
course_completion_crit_compl.criteriaid courcomplcritcoml_cri_fk R
course bigint 10 0 courcompcrit_cou_fk R
criteriatype bigint 10 0

Type of criteria

module varchar 100 null

Type of module (if using module criteria type)

moduleinstance bigint 10 null courcompcrit_min_fk R

Module instance id (if using module criteria type)

courseinstance bigint 10 null courcompcrit_cin_fk R

Course instance id (if using course criteria type)

enrolperiod bigint 10 null

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

timeend bigint 10 null

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

gradepass decimal 10 null

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

role bigint 10 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