0 rows


Contains the basic information about an advanced grading for


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
grading_instances.definitionid gradinst_def2_fkR
gradingform_guide_comments.definitionid gradguidcomm_def2_fkR
gradingform_guide_criteria.definitionid gradguidcrit_def2_fkR
gradingform_rubric_criteria.definitionid gradrubrcrit_def2_fkR
areaid BIGINT 19 null graddefi_are2_fkR
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 graddefi_use4_fkR

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 graddefi_use3_fkR

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


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
graddefi_are4_ix Performance Asc areaid
graddefi_aremet2_uix Must be unique Asc/Asc areaid + method
graddefi_use6_ix Performance Asc usermodified
graddefi_use8_ix Performance Asc usercreated