| id |
bigint(10)
|
|
|
|
| courseid |
bigint(10)
|
|
|
|
| categoryid |
bigint(10)
|
|
|
|
| itemname |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| itemtype |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| itemmodule |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| iteminstance |
bigint(10)
|
|
|
|
| itemnumber |
bigint(10)
|
|
|
|
| iteminfo |
longtext
|
utf8mb4_unicode_ci
|
|
|
| idnumber |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| calculation |
longtext
|
utf8mb4_unicode_ci
|
|
|
| gradetype |
smallint(4)
|
|
|
|
| grademax |
decimal(10,5)
|
|
|
|
| grademin |
decimal(10,5)
|
|
|
|
| scaleid |
bigint(10)
|
|
|
|
| outcomeid |
bigint(10)
|
|
|
|
| gradepass |
decimal(10,5)
|
|
|
|
| multfactor |
decimal(10,5)
|
|
|
|
| plusfactor |
decimal(10,5)
|
|
|
|
| aggregationcoef |
decimal(10,5)
|
|
|
|
| aggregationcoef2 |
decimal(10,5)
|
|
|
|
| sortorder |
bigint(10)
|
|
|
|
| display |
bigint(10)
|
|
|
|
| decimals |
tinyint(1)
|
|
|
|
| hidden |
bigint(10)
|
|
|
|
| locked |
bigint(10)
|
|
|
|
| locktime |
bigint(10)
|
|
|
|
| needsupdate |
bigint(10)
|
|
|
|
| weightoverride |
tinyint(1)
|
|
|
|
| timecreated |
bigint(10)
|
|
|
|
| timemodified |
bigint(10)
|
|
|
|