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
name VARCHAR 255
description LONGTEXT 2147483647 √ null
descriptionformat TINYINT 3 √ null
status BIGINT 19 0
copiedfromid BIGINT 19 √ null
timecreated BIGINT 19 null
usercreated BIGINT 19 null
user.id graddefi_use4_fkR
timemodified BIGINT 19 null
usermodified BIGINT 19 null
user.id graddefi_use3_fkR
timecopied BIGINT 19 √ 0
options LONGTEXT 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation