Grade Categories History Table Schema (grade_categories_history)


History of grade_categories

grade_categories_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
action bigint 10 0

created/modified/deleted constants

oldid bigint 10 null gradcatehist_old2_fk R
source varchar 255 null

What caused the modification? manual/module/import/...

timemodified bigint 10 null

The last time this grade_item was modified

loggeduser bigint 10 null gradcatehist_log2_fk R

the userid of the person who last modified this outcome

courseid bigint 10 null gradcatehist_cou2_fk R

The course this grade category is part of

parent bigint 10 null gradcatehist_par2_fk R

Categories can be hierarchical

depth bigint 10 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 10 0

A constant pointing to one of the predefined aggregation strategies (none, mean,median,sum, etc)

keephigh bigint 10 0

Keep only the X highest items

droplow bigint 10 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

Table contained -1 rows

grade_categories_history table 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

grade_categories_history table relationships