Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||||||||||
category | BIGINT | 19 | 0 |
|
|
|||||||||||||
sortorder | BIGINT | 19 | 0 |
|
|
|||||||||||||
fullname | VARCHAR | 254 |
|
|
||||||||||||||
shortname | VARCHAR | 255 |
|
|
||||||||||||||
idnumber | VARCHAR | 100 |
|
|
||||||||||||||
summary | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||||
summaryformat | TINYINT | 3 | 0 |
|
|
|||||||||||||
format | VARCHAR | 21 | topics |
|
|
|||||||||||||
showgrades | TINYINT | 3 | 1 |
|
|
|||||||||||||
newsitems | MEDIUMINT | 7 | 1 |
|
|
|||||||||||||
startdate | BIGINT | 19 | 0 |
|
|
|||||||||||||
enddate | BIGINT | 19 | 0 |
|
|
|||||||||||||
relativedatesmode | BIT | 1 | 0 |
|
|
Whether to let this course display course- or activity-related dates relative to the user’s enrolment date in this course. |
||||||||||||
marker | BIGINT | 19 | 0 |
|
|
|||||||||||||
maxbytes | BIGINT | 19 | 0 |
|
|
|||||||||||||
legacyfiles | SMALLINT | 5 | 0 |
|
|
course files are not necessary any more: 0 no legacy files, 1 legacy files disabled, 2 legacy files enabled |
||||||||||||
showreports | SMALLINT | 5 | 0 |
|
|
|||||||||||||
visible | BIT | 1 | 1 |
|
|
|||||||||||||
visibleold | BIT | 1 | 1 |
|
|
the state of visible field when hiding parent category, this helps us to recover hidden states when unhiding the parent category later |
||||||||||||
downloadcontent | BIT | 1 | √ | null |
|
|
||||||||||||
groupmode | SMALLINT | 5 | 0 |
|
|
|||||||||||||
groupmodeforce | SMALLINT | 5 | 0 |
|
|
|||||||||||||
defaultgroupingid | BIGINT | 19 | 0 |
|
|
default grouping used in course modules, does not have key intentionally |
||||||||||||
lang | VARCHAR | 30 |
|
|
Forced language for this course. Null or '' means ‘Do not force’. Otherwise a Moodle lang pack name like ‘fr’ or ‘en_us’. |
|||||||||||||
calendartype | VARCHAR | 30 |
|
|
||||||||||||||
theme | VARCHAR | 50 |
|
|
||||||||||||||
timecreated | BIGINT | 19 | 0 |
|
|
|||||||||||||
timemodified | BIGINT | 19 | 0 |
|
|
|||||||||||||
requested | BIT | 1 | 0 |
|
|
|||||||||||||
enablecompletion | BIT | 1 | 0 |
|
|
1 = allow use of ‘completion’ progress-tracking on this course. 0 = disable completion tracking on this course. |
||||||||||||
completionnotify | BIT | 1 | 0 |
|
|
Notify users when they complete this course |
||||||||||||
cacherev | BIGINT | 19 | 0 |
|
|
Incrementing revision for validating the course content cache |
||||||||||||
originalcourseid | BIGINT | 19 | √ | null |
|
|
the id of the source course when a new course originates from a restore of another course on the same site. |
|||||||||||
showactivitydates | BIT | 1 | 0 |
|
|
Whether to display activity dates to user. 0 = do not display, 1 = display activity dates |
||||||||||||
showcompletionconditions | BIT | 1 | √ | null |
|
|
Whether to display completion conditions to user. 0 = do not display, 1 = display conditions |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
cour_cat_ix | Performance | Asc | category |
cour_idn_ix | Performance | Asc | idnumber |
cour_ori_ix | Performance | Asc | originalcourseid |
cour_sho_ix | Performance | Asc | shortname |
cour_sor_ix | Performance | Asc | sortorder |