grade_letters table columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| contextid | BIGINT | 19 | null |
|
|
What contextid does this letter apply to (for now these will always be courses, but later...) |
||||
| lowerboundary | DECIMAL | 10,5 | null |
|
|
The lower boundary of the letter. Its upper boundary is the lower boundary of the next highest letter, unless there is none above, in which case it's grademax for that grade_item. |
||||
| letter | VARCHAR | 255 |
|
|
The display value of the letter. Can be any character or string of characters (OK, A, 10% etc..) |
Table contained -1 rows
grade_letters table indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| gradlett_conlowlet_uix | Must be unique | Asc/Asc/Asc | contextid + lowerboundary + letter |
grade_letters table relationships
Close relationships within degrees of separation
