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

Course module 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_cou_ix Performance Asc course

Relationships