Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||||||||
| courseid | BIGINT | 19 | √ | null |
|
|
The course this item is part of |
|||||||||
| categoryid | BIGINT | 19 | √ | null |
|
|
(optional) the category group this item belongs to |
|||||||||
| itemname | VARCHAR | 255 | √ | null |
|
|
The name of this item (pushed in by the module) |
|||||||||
| itemtype | VARCHAR | 30 |
|
|
'mod', 'blocks', 'import', 'calculated' etc |
|||||||||||
| itemmodule | VARCHAR | 30 | √ | null |
|
|
'forum', 'quiz', 'csv', etc |
|||||||||
| iteminstance | BIGINT | 19 | √ | null |
|
|
id of the item module |
|||||||||
| itemnumber | BIGINT | 19 | √ | null |
|
|
Can be used to distinguish multiple grades for an activity |
|||||||||
| iteminfo | LONGTEXT | 2147483647 | √ | null |
|
|
Info and notes about this item XXX |
|||||||||
| idnumber | VARCHAR | 255 | √ | null |
|
|
Arbitrary idnumber provided by the module responsible |
|||||||||
| calculation | LONGTEXT | 2147483647 | √ | null |
|
|
Formula describing how to derive this grade from other items, referring to them using giXXX where XXX is grade item id … eg something like: =sin(square(#gi20#)) + #gi30# |
|||||||||
| gradetype | SMALLINT | 5 | 1 |
|
|
0 = none, 1 = value, 2 = scale, 3 = text |
||||||||||
| grademax | DECIMAL | 10,5 | 100.00000 |
|
|
What is the maximum allowable grade? |
||||||||||
| grademin | DECIMAL | 10,5 | 0.00000 |
|
|
What is the minimum allowable grade? |
||||||||||
| scaleid | BIGINT | 19 | √ | null |
|
|
If this grade is based on a scale, which one is it? |
|||||||||
| outcomeid | BIGINT | 19 | √ | null |
|
|
If this grade is related to an outcome, which one is it? |
|||||||||
| gradepass | DECIMAL | 10,5 | 0.00000 |
|
|
What grade is needed to pass? grademin < gradepass <= grademax |
||||||||||
| multfactor | DECIMAL | 10,5 | 1.00000 |
|
|
Multiply all grades by this |
||||||||||
| plusfactor | DECIMAL | 10,5 | 0.00000 |
|
|
Add this to all grades |
||||||||||
| aggregationcoef | DECIMAL | 10,5 | 0.00000 |
|
|
Aggregation coefficient used for category weights or other aggregation types |
||||||||||
| aggregationcoef2 | DECIMAL | 10,5 | 0.00000 |
|
|
Aggregation coefficient used for weights in aggregation types with both extra credit and weight |
||||||||||
| sortorder | BIGINT | 19 | 0 |
|
|
Sorting order of the columns |
||||||||||
| display | BIGINT | 19 | 0 |
|
|
Display as real grades, percentages (in reference to the minimum and maximum grades) or letters (A, B, C etc..), or course default (0) |
||||||||||
| decimals | BIT | 1 | √ | null |
|
|
Also known as precision, the number of digits after the decimal point symbol. |
|||||||||
| BIGINT | 19 | 0 |
|
|
1 is hidden, > 1 is a date to hide until (prevents viewing) |
|||||||||||
| locked | BIGINT | 19 | 0 |
|
|
1 is locked, > 1 is a date to lock until (prevents update) |
||||||||||
| locktime | BIGINT | 19 | 0 |
|
|
lock all final grades after this date |
||||||||||
| needsupdate | BIGINT | 19 | 0 |
|
|
If this flag is set, then the whole column will be recalculated |
||||||||||
| weightoverride | BIT | 1 | 0 |
|
|
|||||||||||
| timecreated | BIGINT | 19 | √ | null |
|
|
The first time this grade_item was created |
|||||||||
| timemodified | BIGINT | 19 | √ | null |
|
|
The last time this grade_item was modified |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| graditem_cat_ix | Performance | Asc | categoryid |
| graditem_cou_ix | Performance | Asc | courseid |
| graditem_gra_ix | Performance | Asc | gradetype |
| graditem_idncou_ix | Performance | Asc/Asc | idnumber + courseid |
| graditem_iteiteitecou_ix | Performance | Asc/Asc/Asc/Asc | itemtype + itemmodule + iteminstance + courseid |
| graditem_itenee_ix | Performance | Asc/Asc | itemtype + needsupdate |
| graditem_locloc_ix | Performance | Asc/Asc | locked + locktime |
| graditem_out_ix | Performance | Asc | outcomeid |
| graditem_sca_ix | Performance | Asc | scaleid |