Table testsql_comments.import_batches Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
import_batch_id int 10  √ 
import_records
unique identifier and primary key
matcher_id int 10  √  null
the id of the match rule used (matchpoints.matcher_id)
template_id int 10  √  null
branchcode varchar 10  √  null
num_records int 10 0 number of records in the file
num_items int 10 0 number of items in the file
upload_timestamp timestamp 19 CURRENT_TIMESTAMP date and time the file was uploaded
overlay_action enum 12 create_new how to handle duplicate records
nomatch_action enum 11 create_new how to handle records where no match is found
item_action enum 20 always_add what to do with item records
import_status enum 9 staging the status of the imported file
batch_type enum 10 batch where this batch has come from
record_type enum 8 biblio type of record in the batch
file_name varchar 100  √  null the name of the file uploaded
comments longtext 2147483647  √  null any comments added when the file was uploaded

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Indexes:
Column(s) Type Sort
import_batch_id Primary key Asc
branchcode Performance Asc

Close relationships  within of separation: