Table testsql_comments.import_records Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
import_record_id int 10  √ 
import_auths.import_record_id import_auths_ibfk_1 C
import_biblios.import_record_id import_biblios_ibfk_1 C
import_items.import_record_id import_items_ibfk_1 C
import_record_matches.import_record_id import_record_matches_ibfk_1 C
import_batch_id int 10
import_batches.import_batch_id import_records_ifbk_1 C
branchcode varchar 10  √  null
branches.branchcode Implied Constraint R
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 Constraint Name
import_record_id Primary key Asc PRIMARY
import_batch_id + record_type Performance Asc/Asc batch_id_record_type
import_batch_id + record_sequence Performance Asc/Asc batch_sequence
branchcode Performance Asc branchcode

Close relationships: