0 rows


Temporary table for importing grades


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
itemid BIGINT 19 null gradimpovalu_ite2_fkR

if set, this points to existing grade_items id

newgradeitem BIGINT 19 null gradimpovalu_new2_fkR

if set, points to the id of grade_import_newitem

userid BIGINT 19 null
finalgrade DECIMAL 10,5 null

raw grade value

feedback LONGTEXT 2147483647 null
importcode BIGINT 19 null

similar to backup_code, a unique batch code for identifying one batch of imports

importer BIGINT 19 null gradimpovalu_imp2_fkR
importonlyfeedback BIT 1 0


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradimpovalu_imp4_ix Performance Asc importer
gradimpovalu_ite4_ix Performance Asc itemid
gradimpovalu_new4_ix Performance Asc newgradeitem