Grading Definitions Table Schema (grading_definitions)


Description

Contains the basic information about an advanced grading form defined in the given gradable area

grading_definitions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
grading_instances.definitionid gradinst_def2_fk R
gradingform_guide_comments.definitionid gradguidcomm_def2_fk R
gradingform_guide_criteria.definitionid gradguidcrit_def2_fk R
gradingform_rubric_criteria.definitionid gradrubrcrit_def2_fk R
areaid BIGINT 19 null
grading_areas.id graddefi_are2_fk R
method VARCHAR 100

The name of the plugin providing this grading form
name VARCHAR 255

The title of the form that helps users to identify it
description LONGTEXT 2147483647 √ null

More detailed description of the form
descriptionformat TINYINT 3 √ null

Format of the description field
status BIGINT 19 0

Status of the form definition, by default in the under-construction state
copiedfromid BIGINT 19 √ null

The id of the original definition that this was initially copied from or null if it was from scratch
timecreated BIGINT 19 null

The timestamp of when the form definition was created initially
usercreated BIGINT 19 null
user.id graddefi_use4_fk R

The ID of the user who created this definition and is considered as its owner for access control purposes
timemodified BIGINT 19 null

The time stamp of when the form definition was modified recently
usermodified BIGINT 19 null
user.id graddefi_use3_fk R

The ID of the user who did the most recent modification
timecopied BIGINT 19 √ 0

The timestamp of when this form was most recently copied into another area
options LONGTEXT 2147483647 √ null

General field to be used by plugins as a general storage place for their own settings

Table contained -1 rows

grading_definitions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
graddefi_are_ix Performance Asc areaid
graddefi_aremet_uix Must be unique Asc/Asc areaid + method
graddefi_use2_ix Performance Asc usercreated
graddefi_use_ix Performance Asc usermodified

grading_definitions table relationships

Close relationships within degrees of separation