| id |
bigint(10)
|
|
|
|
| category |
bigint(10)
|
|
|
|
| sortorder |
bigint(10)
|
|
|
|
| fullname |
varchar(254)
|
utf8mb4_unicode_ci
|
|
|
| shortname |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| idnumber |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| summary |
longtext
|
utf8mb4_unicode_ci
|
|
|
| summaryformat |
tinyint(2)
|
|
|
|
| format |
varchar(21)
|
utf8mb4_unicode_ci
|
|
|
| showgrades |
tinyint(2)
|
|
|
|
| newsitems |
mediumint(5)
|
|
|
|
| startdate |
bigint(10)
|
|
|
|
| enddate |
bigint(10)
|
|
|
|
| relativedatesmode |
tinyint(1)
|
|
|
|
| marker |
bigint(10)
|
|
|
|
| maxbytes |
bigint(10)
|
|
|
|
| legacyfiles |
smallint(4)
|
|
|
|
| showreports |
smallint(4)
|
|
|
|
| visible |
tinyint(1)
|
|
|
|
| visibleold |
tinyint(1)
|
|
|
|
| downloadcontent |
tinyint(1)
|
|
|
|
| groupmode |
smallint(4)
|
|
|
|
| groupmodeforce |
smallint(4)
|
|
|
|
| defaultgroupingid |
bigint(10)
|
|
|
|
| lang |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| calendartype |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| theme |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| timecreated |
bigint(10)
|
|
|
|
| timemodified |
bigint(10)
|
|
|
|
| requested |
tinyint(1)
|
|
|
|
| enablecompletion |
tinyint(1)
|
|
|
|
| completionnotify |
tinyint(1)
|
|
|
|
| cacherev |
bigint(10)
|
|
|
|
| originalcourseid |
bigint(10)
|
|
|
|
| showactivitydates |
tinyint(1)
|
|
|
|
| showcompletionconditions |
tinyint(1)
|
|
|
|
| pdfexportfont |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|