import_records


Columns

Column Type Size Nulls Auto Default Children Parents Comments
import_record_id INT 10 √ null
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 null
import_batches.import_batch_id import_records_ifbk_1 C
branchcode VARCHAR 10 √ null
record_sequence INT 10 0
upload_timestamp TIMESTAMP 19 current_timestamp()
import_date DATE 10 √ null
marc LONGBLOB 2147483647 null
marcxml LONGTEXT 2147483647 null
marcxml_old LONGTEXT 2147483647 null
record_type enum('biblio', 'auth', 'holdings') 8 biblio
overlay_status enum('no_match', 'auto_match', 'manual_match', 'match_applied') 13 no_match
status enum('error', 'staged', 'imported', 'reverted', 'items_reverted', 'ignored') 14 staged
import_error LONGTEXT 2147483647 √ null
encoding VARCHAR 40
z3950random VARCHAR 40 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc import_record_id
batch_id_record_type Performance Asc/Asc import_batch_id + record_type
batch_sequence Performance Asc/Asc import_batch_id + record_sequence
branchcode Performance Asc branchcode

Relationships

Close relationships within degrees of separation