grade_categories

0 rows


Description

This table keeps information about categories, used for grou

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
grade_categories.parent gradcate_par2_fkR
grade_categories_history.oldid gradcatehist_old2_fkR
grade_categories_history.parent gradcatehist_par2_fkR
grade_items.categoryid graditem_cat2_fkR
grade_items_history.categoryid graditemhist_cat2_fkR
courseid BIGINT 19 null
course.id gradcate_cou2_fkR
parent BIGINT 19 √ null
grade_categories.id gradcate_par2_fkR
depth BIGINT 19 0
path VARCHAR 255 √ null
fullname VARCHAR 255
aggregation BIGINT 19 0
keephigh BIGINT 19 0
droplow BIGINT 19 0
aggregateonlygraded BIT 1 0
aggregateoutcomes BIT 1 0
timecreated BIGINT 19 null
timemodified BIGINT 19 null
hidden BIT 1 0

Indexes

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

Relationships

Close relationships within degrees of separation