course_completion_criteria

0 rows


Description

Course completion criteria

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
course BIGINT 19 0
course.id course_completion_criteria_erd_course_idR
criteriatype BIGINT 19 0

Type of criteria
module VARCHAR 100 √ null

Type of module (if using module criteria type)
moduleinstance BIGINT 19 √ null

Module instance id (if using module criteria type)
courseinstance BIGINT 19 √ null

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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courcompcrit_cou2_ix Performance Asc course

Relationships

Close relationships within degrees of separation