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
courseid BIGINT 19 null gradoutc_cou2_fkR
shortname VARCHAR 255
fullname LONGTEXT 2147483647 null
scaleid BIGINT 19 null gradoutc_sca2_fkR
description LONGTEXT 2147483647 null
descriptionformat TINYINT 3 0
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null gradoutc_use2_fkR


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