Gradingform Guide Criteria Table Schema (gradingform_guide_criteria)


Description

Stores the rows of the criteria grid.

gradingform_guide_criteria table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
gradingform_guide_fillings.criterionid gradguidfill_cri2_fk R
definitionid bigint 10 null
grading_definitions.id gradguidcrit_def2_fk R

The ID of the form definition this criterion is part of

sortorder bigint 10 null

Defines the order of the criterion in the guide

shortname varchar 255

shortname of this criterion

description longtext 2147483647 null

The criterion description for students

descriptionformat tinyint 2 null

The format of the description field

descriptionmarkers longtext 2147483647 null

Description for Markers

descriptionmarkersformat tinyint 2 null
maxscore decimal 10 null

maximum grade that can be assigned using this criterion

Table contained -1 rows

gradingform_guide_criteria table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradguidcrit_def_ix Performance Asc definitionid

gradingform_guide_criteria table relationships