Grade Import Newitem Table Schema (grade_import_newitem)


Description

temporary table for storing new grade_item names from grade import

grade_import_newitem table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
grade_import_values.newgradeitem gradimpovalu_new2_fk R
itemname VARCHAR 255

new grade item name
importcode BIGINT 19 null

import batch code for identification
importer BIGINT 19 null
user.id gradimponewi_imp2_fk R

user importing the data

Table contained -1 rows

grade_import_newitem table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradimponewi_imp_ix Performance Asc importer

grade_import_newitem table relationships

Close relationships within degrees of separation