Scale Table Schema (scale)


Description

Defines grading scales

scale table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
competency.scaleid Implied Constraint R
competency_framework.scaleid Implied Constraint R
grade_grades.rawscaleid gradgrad_raw2_fk R
grade_grades_history.rawscaleid gradgradhist_raw2_fk R
grade_items.scaleid graditem_sca2_fk R
grade_items_history.scaleid graditemhist_sca2_fk R
grade_outcomes.scaleid gradoutc_sca2_fk R
grade_outcomes_history.scaleid gradoutchist_sca2_fk R
rating.scaleid Implied Constraint R
scale_history.oldid scalhist_old2_fk R
courseid BIGINT 19 0
course.id Implied Constraint R
userid BIGINT 19 0
user.id Implied Constraint R
name VARCHAR 255
scale LONGTEXT 2147483647 null
description LONGTEXT 2147483647 null
descriptionformat TINYINT 3 0
timemodified BIGINT 19 0

Table contained -1 rows

scale table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
scal_cou_ix Performance Asc courseid

scale table relationships