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 |