# grade_grades_history

0 rows

### Description

History table

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
action | BIGINT | 19 |  |  | 0 |  |  | created/modified/deleted constants
oldid | BIGINT | 19 |  |  | null |  |
grade_grades.id | gradgradhist_old2_fkR
source | VARCHAR | 255 | √ |  | null |  |  | What caused the modification? manual/module/import/…
timemodified | BIGINT | 19 | √ |  | null |  |  | The last time this grade_item was modified
loggeduser | BIGINT | 19 | √ |  | null |  |
user.id | gradgradhist_log2_fkR
| the userid of the person who last modified this outcome
itemid | BIGINT | 19 |  |  | null |  |
grade_items.id | gradgradhist_ite2_fkR
| The item this grade belongs to
userid | BIGINT | 19 |  |  | null |  |
user.id | gradgradhist_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 | gradgradhist_raw2_fkR
| If this grade is based on a scale, which one was it?
usermodified | BIGINT | 19 | √ |  | null |  |
user.id | gradgradhist_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

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
gradgradhist_act_ix | Performance | Asc | action
gradgradhist_ite_ix | Performance | Asc | itemid
gradgradhist_log_ix | Performance | Asc | loggeduser
gradgradhist_old_ix | Performance | Asc | oldid
gradgradhist_raw_ix | Performance | Asc | rawscaleid
gradgradhist_tim_ix | Performance | Asc | timemodified
gradgradhist_use2_ix | Performance | Asc | usermodified
gradgradhist_use_ix | Performance | Asc | userid
gradgradhist_useitetim_ix | Performance | Asc/Asc/Asc | userid + itemid + timemodified

### Relationships