Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||
itemid | BIGINT | 19 | null |
|
|
The item this grade belongs to |
||||
userid | BIGINT | 19 | null |
|
|
The user who this grade is for |
||||
rawgrade | DECIMAL | 10,5 | √ | null |
|
|
If the grade is a float value (or has been converted to one) |
|||
rawgrademax | DECIMAL | 10,5 | 100.00000 |
|
|
The maximum allowable grade when this was created |
||||
rawgrademin | DECIMAL | 10,5 | 0.00000 |
|
|
The minimum allowable grade when this was created |
||||
rawscaleid | BIGINT | 19 | √ | null |
|
|
If this grade is based on a scale, which one was it? |
|||
usermodified | BIGINT | 19 | √ | null |
|
|
the userid of the person who last modified this grade |
|||
finalgrade | DECIMAL | 10,5 | √ | null |
|
|
The final grade (cached) after all calculations are made |
|||
BIGINT | 19 | 0 |
|
|
show 0, hide 1 or hide until date |
|||||
locked | BIGINT | 19 | 0 |
|
|
not locked 0, locked from date |
||||
locktime | BIGINT | 19 | 0 |
|
|
automatic locking of final grade, 0 means none, date otherwise |
||||
exported | BIGINT | 19 | 0 |
|
|
date of last grade export, 0 if none |
||||
overridden | BIGINT | 19 | 0 |
|
|
indicates grade overridden from gradebook, 0 means none, date means overridden |
||||
excluded | BIGINT | 19 | 0 |
|
|
grade excluded from aggregation functions, date means when excluded |
||||
feedback | LONGTEXT | 2147483647 | √ | null |
|
|
grading feedback |
|||
feedbackformat | BIGINT | 19 | 0 |
|
|
format of feedback text |
||||
information | LONGTEXT | 2147483647 | √ | null |
|
|
optiona information |
|||
informationformat | BIGINT | 19 | 0 |
|
|
format of information text |
||||
timecreated | BIGINT | 19 | √ | null |
|
|
the time this grade was first created |
|||
timemodified | BIGINT | 19 | √ | null |
|
|
the time this grade was last modified |
|||
aggregationstatus | VARCHAR | 10 | unknown |
|
|
One of several values describing how this grade_grade was used when calculating the aggregation. Possible values are "unknown", "dropped", "novalue", "used" |
||||
aggregationweight | DECIMAL | 10,5 | √ | null |
|
|
If the aggregationstatus == ‘included’, then this is the percent this item contributed to the aggregation. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
gradgrad_ite_ix | Performance | Asc | itemid |
gradgrad_locloc_ix | Performance | Asc/Asc | locked + locktime |
gradgrad_raw_ix | Performance | Asc | rawscaleid |
gradgrad_use2_ix | Performance | Asc | usermodified |
gradgrad_use_ix | Performance | Asc | userid |
gradgrad_useite_uix | Must be unique | Asc/Asc | userid + itemid |