# grade_import_values

0 rows

### Description

Temporary table for importing grades

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
itemid | BIGINT | 19 | √ |  | null |  |
grade_items.id | gradimpovalu_ite2_fkR
| if set, this points to existing grade_items id
newgradeitem | BIGINT | 19 | √ |  | null |  |
grade_import_newitem.id | gradimpovalu_new2_fkR
| if set, points to the id of grade_import_newitem
userid | BIGINT | 19 |  |  | null |  |
user.id | gradimpovalu_use2_fkR
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 |  |
user.id | gradimpovalu_imp2_fkR
importonlyfeedback | BIT | 1 | √ |  | 0 |  |  |

### 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
gradimpovalu_use_ix | Performance | Asc | userid

### Relationships