scale

0 rows


Description

Defines grading scales

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
competency.scaleid comp_sca2_fkR
competency_framework.scaleid compfram_sca2_fkR
grade_grades.rawscaleid gradgrad_raw2_fkR
grade_grades_history.rawscaleid gradgradhist_raw2_fkR
grade_items.scaleid graditem_sca2_fkR
grade_items_history.scaleid graditemhist_sca2_fkR
grade_outcomes.scaleid gradoutc_sca2_fkR
grade_outcomes_history.scaleid gradoutchist_sca2_fkR
rating.scaleid rati_sca2_fkR
scale_history.oldid scalhist_old2_fkR
courseid BIGINT 19 0
course.id Implied ConstraintR
userid BIGINT 19 0
user.id scal_use2_fkR
name VARCHAR 255
scale LONGTEXT 2147483647 null
description LONGTEXT 2147483647 null
descriptionformat TINYINT 3 0
timemodified BIGINT 19 0

Indexes

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

Relationships