Grading Areas Table Schema (grading_areas)


Description

Identifies gradable areas where advanced grading can happen. For each area, the current active plugin can be set.

grading_areas table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
grading_definitions.areaid graddefi_are2_fk R
contextid BIGINT 19 null
context.id gradarea_con2_fk R

The context of the gradable area, eg module instance context.
component VARCHAR 100

Frankenstyle name of the component holding this area
areaname VARCHAR 100

The name of gradable area
activemethod VARCHAR 100 √ null

The default grading method (plugin) that should be used for this area

Table contained -1 rows

grading_areas table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradarea_con_ix Performance Asc contextid
gradarea_concomare_uix Must be unique Asc/Asc/Asc contextid + component + areaname

grading_areas table relationships

Close relationships within degrees of separation