grading_definitions

0 rows


Description

Contains the basic information about an advanced grading for

Columns

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
grading_areas.id 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
user.id 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
user.id 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

Indexes

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

Relationships

Close relationships within degrees of separation