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 10 null
action bigint 10 0

created/modified/deleted constants

oldid bigint 10 null
grade_grades.id gradgradhist_old2_fk R
source varchar 255 null

What caused the modification? manual/module/import/...

timemodified bigint 10 null

The last time this grade_item was modified

loggeduser bigint 10 null
user.id gradgradhist_log2_fk R

the userid of the person who last modified this outcome

itemid bigint 10 null
grade_items.id gradgradhist_ite2_fk R

The item this grade belongs to

userid bigint 10 null
user.id gradgradhist_use3_fk R

The user who this grade is for

rawgrade decimal 10 null

If the grade is a float value (or has been converted to one)

rawgrademax decimal 10 100.00000

The maximum allowable grade when this was created

rawgrademin decimal 10 0.00000

The minimum allowable grade when this was created

rawscaleid bigint 10 null
scale.id gradgradhist_raw2_fk R

If this grade is based on a scale, which one was it?

usermodified bigint 10 null
user.id gradgradhist_use4_fk R

the userid of the person who last modified this grade

finalgrade decimal 10 null

The final grade (cached) after all calculations are made

hidden bigint 10 0

show 0, hide 1 or hide until date

locked bigint 10 0

not locked 0, locked from date

locktime bigint 10 0

automatic locking of final grade, 0 means none, date otherwise

exported bigint 10 0

date of last grade export, 0 if none

overridden bigint 10 0

indicates grade overridden from gradebook, 0 means none, date means overridden

excluded bigint 10 0

grade excluded from aggregation functions, date means when excluded

feedback longtext 2147483647 null

grading feedback

feedbackformat bigint 10 0

format of feedback text

information longtext 2147483647 null

optiona information

informationformat bigint 10 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