Table testsql_comments.import_records 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
import_record_id int 10  √ 
import_auths
import_biblios
import_items
import_record_matches
import_batch_id int 10
import_batches
branchcode varchar 10  √  null
record_sequence int 10 0
upload_timestamp timestamp 19 CURRENT_TIMESTAMP
import_date date 10  √  null
marc longblob 2147483647
marcxml longtext 2147483647
marcxml_old longtext 2147483647
record_type enum 8 biblio
overlay_status enum 13 no_match
status enum 14 staged
import_error mediumtext 16777215  √  null
encoding varchar 40
z3950random varchar 40  √  null

Table contained 0 rows at Tue Dec 27 17:18 NZDT 2016

Indexes:
Column(s) Type Sort
import_record_id Primary key Asc
import_batch_id + record_type Performance Asc/Asc
import_batch_id + record_sequence Performance Asc/Asc
branchcode Performance Asc

Close relationships: