Course Modules Table Schema (course_modules)


Description

course_modules table retrofitted from MySQL

course_modules table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
competency_modulecomp.cmid compmodu_cmi2_fk R
course_completion_criteria.moduleinstance courcompcrit_min_fk R
course_modules_completion.coursemoduleid courmoducompl_cou_fk R
local_ld_module.coursemoduleid localdmodu_cou2_fk R
course bigint 10 0
course.id courmodu_cou_fk R
module bigint 10 0
modules.id courmodu_mod_fk R
instance bigint 10 0
section bigint 10 0
idnumber varchar 100 null

customizable idnumber

added bigint 10 0
score smallint 4 0
indent mediumint 5 0
visible BIT 1 1
visibleoncoursepage BIT 1 1

If stealth visibility is allowed for the course, this controls whether activity is visible on course page

visibleold BIT 1 1
groupmode smallint 4 0
groupingid bigint 10 0
groupings.id courmodu_gro2_fk R
completion BIT 1 0

Whether the completion-tracking facilities are enabled for this activity. 0 = not enabled (database default) 1 = manual tracking, user can tick this activity off (UI default for most activity types) 2 = automatic tracking, system should mark completion according to rules specified in course_moduleS_completion

completiongradeitemnumber bigint 10 null

Grade-item number used to track automatic completion, if applicable.

completionview BIT 1 0

Controls whether a page view is part of the automatic completion requirements for this activity. 0 = view not required 1 = view required

completionexpected bigint 10 0

Date at which students are expected to complete this activity. This field is used when displaying student progress.

showdescription BIT 1 0

Some module types support a 'description' which shows within the module pages. This option controls whether it also displays on the course main page. 0 = does not display (default), 1 = displays

availability longtext 2147483647 null

Availability restrictions for viewing this activity, in JSON format. Null if no restrictions.

deletioninprogress BIT 1 0

Table contained -1 rows

course_modules table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courmodu_cou_ix Performance Asc course
courmodu_gro_ix Performance Asc groupingid
courmodu_idncou_ix Performance Asc/Asc idnumber + course
courmodu_ins_ix Performance Asc instance
courmodu_mod_ix Performance Asc module
courmodu_vis_ix Performance Asc visible

course_modules table relationships