Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| import_batch_id | INT | 10 | √ | null |
|
|
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('replace', 'create_new', 'use_template', 'ignore') | 12 | create_new |
|
|
how to handle duplicate records |
|||||
| nomatch_action | enum('create_new', 'ignore') | 11 | create_new |
|
|
how to handle records where no match is found |
|||||
| item_action | enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore', 'replace') | 20 | always_add |
|
|
what to do with item records |
|||||
| import_status | enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') | 9 | staging |
|
|
the status of the imported file |
|||||
| batch_type | enum('batch', 'z3950', 'webservice') | 10 | batch |
|
|
where this batch has come from |
|||||
| record_type | enum('biblio', 'auth', 'holdings') | 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 |
||||
| profile_id | INT | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | import_batch_id |
| branchcode | Performance | Asc | branchcode |
| import_batches_ibfk_1 | Performance | Asc | profile_id |
Relationships
Close relationships within degrees of separation
