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 19 √ null
competency_modulecomp.cmid compmodu_cmi2_fk R
course_completion_criteria.moduleinstance courcompcrit_mod2_fk R
course_modules_completion.coursemoduleid courmoducomp_cou2_fk R
local_ld_module.coursemoduleid localdmodu_cou2_fk R
course BIGINT 19 0
course.id courmodu_cou2_fk R
module BIGINT 19 0
modules.id courmodu_mod2_fk R
instance BIGINT 19 0
section BIGINT 19 0
idnumber VARCHAR 100 √ null

customizable idnumber
added BIGINT 19 0
score SMALLINT 5 0
indent MEDIUMINT 7 0
visible BIT 1 1
visibleoncoursepage BIT 1 1

Totara: Not used ATM, as we didn't take Stealth mode changes. If stealth visibility is allowed for the course, this controls whether activity is visible on course page
visibleold BIT 1 1
groupmode SMALLINT 5 0
groupingid BIGINT 19 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 19 √ 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 19 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

Close relationships within degrees of separation