Grade Letters Table Schema (grade_letters)


Description

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

grade_letters table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
contextid BIGINT 19 null
context.id Implied Constraint R

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