# grade_grades

0 rows

### Description

grade_grades This table keeps individual grades for each user and each item, exactly as imported or submitted by modules. The rawgrademax/min and rawscaleid are stored here to record the values at the time the grade was stored, because teachers might change this for an activity! All the results are normalised/resampled for the final grade value.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
grade_grades_history.oldid | gradgradhist_old2_fkR
itemid | BIGINT | 19 |  |  | null |  |
grade_items.id | gradgrad_ite2_fkR
| The item this grade belongs to
userid | BIGINT | 19 |  |  | null |  |
user.id | gradgrad_use3_fkR
| 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 |  |
scale.id | gradgrad_raw2_fkR
| If this grade is based on a scale, which one was it?
usermodified | BIGINT | 19 | √ |  | null |  |
user.id | gradgrad_use4_fkR
| the userid of the person who last modified this grade
finalgrade | DECIMAL | 10,5 | √ |  | null |  |  | The final grade (cached) after all calculations are made
hidden | 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.
deductedmark | DECIMAL | 10,5 |  |  | 0.00000 |  |  | The mark deducted from final grade

### 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

### Relationships