# grade_letters

0 rows

### Description

Repository for grade letters, for courses and other moodle entities that use grades.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
contextid | BIGINT | 19 |  |  | null |  |
context.id | grade_letters_erd_contextR
| 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

### Relationships