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..) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| gradlett_conlowlet_uix | Must be unique | Asc/Asc/Asc | contextid + lowerboundary + letter |