app_course_modules_availability

0 rows


Description

Table stores conditions that affect whether a module/activity is currently available to students or not.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_course_modules_availability_id_seq'::regclass)
coursemoduleid int8 19 null
app_course_modules.id Defined in XMLR
sourcecmid int8 19 √ null
app_course_modules.id Defined in XMLR
requiredcompletion int2 5 √ null
gradeitemid int8 19 √ null
app_grade_items.id Defined in XMLR
grademin numeric 10,5 √ null
grademax numeric 10,5 √ null

Indexes

Constraint Name Type Sort Column(s)
app_courmoduavai_id_pk Primary key Asc id
app_courmoduavai_cou_ix Performance Asc coursemoduleid
app_courmoduavai_gra_ix Performance Asc gradeitemid
app_courmoduavai_sou_ix Performance Asc sourcecmid

Relationships

Close relationships within degrees of separation