# 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 | 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 |  |
course.id | 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 |  |
scale.id | 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 |  |
user.id | gradoutc_use2_fkR
| the userid of the person who last modified this outcome

### 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

### Relationships