0 rows


course_modules table retrofitted from MySQL


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
block_recentlyaccesseditems.cmid blocrece_cmi2_fkR
competency_modulecomp.cmid compmodu_cmi2_fkR
course_modules_completion.coursemoduleid course_modules_completion_erd_course_modulesR
course BIGINT 19 0 course_modules_erd_course_idR
module BIGINT 19 0
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

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 courmodu_gro2_fkR
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


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courmodu_cou2_ix Performance Asc course
courmodu_gro4_ix Performance Asc groupingid
courmodu_idncou2_ix Performance Asc/Asc idnumber + course
courmodu_ins2_ix Performance Asc instance
courmodu_mod2_ix Performance Asc module
courmodu_vis2_ix Performance Asc visible