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