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 19 √ null
gradingform_guide_fillings.criterionid gradguidfill_cri2_fk R
definitionid BIGINT 19 null
grading_definitions.id gradguidcrit_def2_fk R

The ID of the form definition this criterion is part of
sortorder BIGINT 19 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 3 √ null

The format of the description field
descriptionmarkers LONGTEXT 2147483647 √ null

Description for Markers
descriptionmarkersformat TINYINT 3 √ null
maxscore DECIMAL 10,5 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

Close relationships within degrees of separation