0 rows


This table describes the outcomes used in the system. An out


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
grade_items.outcomeid graditem_out2_fkR
grade_items_history.outcomeid graditemhist_out2_fkR
grade_outcomes_courses.outcomeid gradoutccour_out2_fkR
grade_outcomes_history.oldid gradoutchist_old2_fkR

id of the table

courseid BIGINT 19 null gradoutc_cou2_fkR

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 gradoutc_sca2_fkR

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 gradoutc_use2_fkR

the userid of the person who last modified this outcome


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradoutc_cou4_ix Performance Asc courseid
gradoutc_cousho2_uix Must be unique Asc/Asc courseid + shortname
gradoutc_sca4_ix Performance Asc scaleid
gradoutc_use4_ix Performance Asc usermodified