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 |