Grade Import Values Table Schema (grade_import_values)


Description

Temporary table for importing grades

grade_import_values table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
itemid bigint 10 null
grade_items.id gradimpovalu_ite2_fk R

if set, this points to existing grade_items id

newgradeitem bigint 10 null
grade_import_newitem.id gradimpovalu_new2_fk R

if set, points to the id of grade_import_newitem

userid bigint 10 null
user.id Implied Constraint R
finalgrade decimal 10 null

raw grade value

feedback longtext 2147483647 null
importcode bigint 10 null

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

importer bigint 10 null
user.id gradimpovalu_imp2_fk R
importonlyfeedback BIT 1 0

Table contained -1 rows

grade_import_values table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradimpovalu_imp_ix Performance Asc importer
gradimpovalu_ite_ix Performance Asc itemid
gradimpovalu_new_ix Performance Asc newgradeitem

grade_import_values table relationships