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

Close relationships within degrees of separation