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 10 null
grading_definitions.areaid graddefi_are2_fk R
contextid bigint 10 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