app_grade_outcomes

0 rows


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)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_grade_outcomes_id_seq'::regclass)
app_grade_items.outcomeid Defined in XMLR
app_grade_items_history.outcomeid Defined in XMLR
app_grade_outcomes_courses.outcomeid Defined in XMLR
app_grade_outcomes_history.oldid Defined in XMLR
courseid int8 19 null
app_course.id Defined in XMLR
shortname varchar 255 ''::character varying
fullname text 2147483647 null
scaleid int8 19 null
app_scale.id Defined in XMLR
description text 2147483647 null
descriptionformat int2 5 0
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null
app_user.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_gradoutc_id_pk Primary key Asc id
app_gradoutc_cou_ix Performance Asc courseid
app_gradoutc_cousho_uix Must be unique Asc/Asc courseid + shortname
app_gradoutc_sca_ix Performance Asc scaleid
app_gradoutc_use_ix Performance Asc usermodified

Relationships