# grade_outcomes_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_outcomes.id | gradoutchist_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 | gradoutchist_log2_fkR
| the userid of the person who last modified this outcome
courseid | BIGINT | 19 | √ |  | null |  |
course.id | gradoutchist_cou2_fkR
| Mostly these are defined site wide ie NULL
shortname | VARCHAR | 255 |  |  |  |  |  | The short name or code for this outcome statement
fullname | LONGTEXT | 2147483647 |  |  | null |  |  | The full description of the outcome (usually 1 sentence)
scaleid | BIGINT | 19 | √ |  | null |  |
scale.id | gradoutchist_sca2_fkR
| The recommended scale for this outcome.
description | LONGTEXT | 2147483647 | √ |  | null |  |  | Outcome description
descriptionformat | TINYINT | 3 |  |  | 0 |  |  |

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
gradoutchist_act_ix | Performance | Asc | action
gradoutchist_cou_ix | Performance | Asc | courseid
gradoutchist_log_ix | Performance | Asc | loggeduser
gradoutchist_old_ix | Performance | Asc | oldid
gradoutchist_sca_ix | Performance | Asc | scaleid
gradoutchist_tim_ix | Performance | Asc | timemodified

### Relationships