# grade_categories_history

0 rows

### Description

History of grade_categories

### 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_categories.id | gradcatehist_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 | gradcatehist_log2_fkR
| the userid of the person who last modified this outcome
courseid | BIGINT | 19 |  |  | null |  |
course.id | gradcatehist_cou2_fkR
| The course this grade category is part of
parent | BIGINT | 19 | √ |  | null |  |
grade_categories.id | gradcatehist_par2_fkR
| Categories can be hierarchical
depth | BIGINT | 19 |  |  | 0 |  |  | How many parents does this category have?
path | VARCHAR | 255 | √ |  | null |  |  | shows the path as /1/2/3 (like course_categories)
fullname | VARCHAR | 255 |  |  |  |  |  | The name of this grade category
aggregation | BIGINT | 19 |  |  | 0 |  |  | A constant pointing to one of the predefined aggregation strategies (none, mean,median,sum, etc)
keephigh | BIGINT | 19 |  |  | 0 |  |  | Keep only the X highest items
droplow | BIGINT | 19 |  |  | 0 |  |  | Drop the X lowest items
aggregateonlygraded | BIT | 1 |  |  | 0 |  |  | aggregate only graded items
aggregateoutcomes | BIT | 1 |  |  | 0 |  |  | Aggregate outcomes
aggregatesubcats | BIT | 1 |  |  | 0 |  |  | This setting was removed from grade_categories. It is kept here only to preserve history.
hidden | BIGINT | 19 |  |  | 0 |  |  |

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
gradcatehist_act_ix | Performance | Asc | action
gradcatehist_cou_ix | Performance | Asc | courseid
gradcatehist_log_ix | Performance | Asc | loggeduser
gradcatehist_old_ix | Performance | Asc | oldid
gradcatehist_par_ix | Performance | Asc | parent
gradcatehist_tim_ix | Performance | Asc | timemodified

### Relationships