Grade Grades History Table Schema (grade_grades_history)


Description

History table

grade_grades_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
action BIGINT 19 0

created/modified/deleted constants
oldid BIGINT 19 null
grade_grades.id gradgradhist_old2_fk R
source VARCHAR 255 √ null

What caused the modification? manual/module/import/...
timemodified BIGINT 19 √ null

The last time this grade_item was modified
loggeduser BIGINT 19 √ null
user.id gradgradhist_log2_fk R

the userid of the person who last modified this outcome
itemid BIGINT 19 null
grade_items.id gradgradhist_ite2_fk R

The item this grade belongs to
userid BIGINT 19 null
user.id gradgradhist_use3_fk R

The user who this grade is for
rawgrade DECIMAL 10,5 √ null

If the grade is a float value (or has been converted to one)
rawgrademax DECIMAL 10,5 100.00000

The maximum allowable grade when this was created
rawgrademin DECIMAL 10,5 0.00000

The minimum allowable grade when this was created
rawscaleid BIGINT 19 √ null
scale.id gradgradhist_raw2_fk R

If this grade is based on a scale, which one was it?
usermodified BIGINT 19 √ null
user.id gradgradhist_use4_fk R

the userid of the person who last modified this grade
finalgrade DECIMAL 10,5 √ null

The final grade (cached) after all calculations are made
hidden BIGINT 19 0

show 0, hide 1 or hide until date
locked BIGINT 19 0

not locked 0, locked from date
locktime BIGINT 19 0

automatic locking of final grade, 0 means none, date otherwise
exported BIGINT 19 0

date of last grade export, 0 if none
overridden BIGINT 19 0

indicates grade overridden from gradebook, 0 means none, date means overridden
excluded BIGINT 19 0

grade excluded from aggregation functions, date means when excluded
feedback LONGTEXT 2147483647 √ null

grading feedback
feedbackformat BIGINT 19 0

format of feedback text
information LONGTEXT 2147483647 √ null

optiona information
informationformat BIGINT 19 0

format of information text

Table contained -1 rows

grade_grades_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradgradhist_act_ix Performance Asc action
gradgradhist_ite_ix Performance Asc itemid
gradgradhist_log_ix Performance Asc loggeduser
gradgradhist_old_ix Performance Asc oldid
gradgradhist_raw_ix Performance Asc rawscaleid
gradgradhist_tim_ix Performance Asc timemodified
gradgradhist_use2_ix Performance Asc usermodified
gradgradhist_use_ix Performance Asc userid
gradgradhist_useitetim_ix Performance Asc/Asc/Asc userid + itemid + timemodified

grade_grades_history table relationships

Close relationships within degrees of separation