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_ite4_ix | Performance | Asc | itemid |
| gradgrad_locloc2_ix | Performance | Asc/Asc | locked + locktime |
| gradgrad_raw4_ix | Performance | Asc | rawscaleid |
| gradgrad_use6_ix | Performance | Asc | userid |
| gradgrad_use8_ix | Performance | Asc | usermodified |
| gradgrad_useite2_uix | Must be unique | Asc/Asc | userid + itemid |
Relationships
Close relationships within degrees of separation
