| id |
BIGINT |
19 |
|
√ |
null |
|
|
|
| action |
BIGINT |
19 |
|
|
0 |
|
|
created/modified/deleted constants |
| oldid |
BIGINT |
19 |
|
|
null |
|
|
|
| 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_fk R
|
|
the userid of the person who last modified this outcome |
| courseid |
BIGINT |
19 |
|
|
null |
|
|
course.id
|
gradcatehist_cou2_fk R
|
|
The course this grade category is part of |
| parent |
BIGINT |
19 |
√ |
|
null |
|
|
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 |
BIT |
1 |
|
|
0 |
|
|
|
