Grade Categories Table Schema (grade_categories)


Description

This table keeps information about categories, used for grouping items.

grade_categories table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
grade_categories.parent gradcate_par2_fk R
grade_categories_history.oldid gradcatehist_old2_fk R
grade_categories_history.parent gradcatehist_par2_fk R
grade_items.categoryid graditem_cat2_fk R
grade_items_history.categoryid graditemhist_cat2_fk R
courseid BIGINT 19 null
course.id gradcate_cou2_fk R

The course this grade category is part of

parent BIGINT 19 null
grade_categories.id gradcate_par2_fk R

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 activities

aggregateoutcomes BIT 1 0

Aggregate outcomes

timecreated BIGINT 19 null
timemodified BIGINT 19 null
hidden BIT 1 0

Table contained -1 rows

grade_categories table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradcate_cou_ix Performance Asc courseid
gradcate_par_ix Performance Asc parent

grade_categories table relationships