Grade Outcomes Table Schema (grade_outcomes)


Description

This table describes the outcomes used in the system. An outcome is a statement tied to a rubric scale from low to high, such as “Not met, Borderline, Met” (stored as 0,1 or 2)

grade_outcomes table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
grade_items.outcomeid graditem_out2_fk R
grade_items_history.outcomeid graditemhist_out2_fk R
grade_outcomes_courses.outcomeid gradoutccour_out2_fk R
grade_outcomes_history.oldid gradoutchist_old2_fk R

id of the table
courseid BIGINT 19 √ null
course.id gradoutc_cou2_fk R

Mostly these are defined site wide ie NULL
shortname VARCHAR 255

The short name or code for this outcome statement
fullname LONGTEXT 2147483647 null

The full description of the outcome (usually 1 sentence)
scaleid BIGINT 19 √ null
scale.id gradoutc_sca2_fk R

The recommended scale for this outcome.
description LONGTEXT 2147483647 √ null

outcome description
descriptionformat TINYINT 3 0
timecreated BIGINT 19 √ null

the time this outcome was first created
timemodified BIGINT 19 √ null

the time this outcome was last updated
usermodified BIGINT 19 √ null
user.id gradoutc_use2_fk R

the userid of the person who last modified this outcome

Table contained -1 rows

grade_outcomes table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradoutc_cou_ix Performance Asc courseid
gradoutc_cousho_uix Must be unique Asc/Asc courseid + shortname
gradoutc_sca_ix Performance Asc scaleid
gradoutc_use_ix Performance Asc usermodified

grade_outcomes table relationships

Close relationships within degrees of separation