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 BIT 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradcatehist_act2_ix Performance Asc action
gradcatehist_cou4_ix Performance Asc courseid
gradcatehist_log4_ix Performance Asc loggeduser
gradcatehist_old4_ix Performance Asc oldid
gradcatehist_par4_ix Performance Asc parent
gradcatehist_tim2_ix Performance Asc timemodified

Relationships