Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
unique identifier and primary key |
|||
| name | VARCHAR | 100 | null |
|
|
name of this profile |
||||
| matcher_id | INT | 10 | √ | null |
|
|
the id of the match rule used (matchpoints.matcher_id) |
|||
| template_id | INT | 10 | √ | null |
|
|
the id of the marc modification template |
|||
| overlay_action | VARCHAR | 50 | √ | null |
|
|
how to handle duplicate records |
|||
| nomatch_action | VARCHAR | 50 | √ | null |
|
|
how to handle records where no match is found |
|||
| item_action | VARCHAR | 50 | √ | null |
|
|
what to do with item records |
|||
| parse_items | BIT | 0 | √ | null |
|
|
should items be parsed |
|||
| record_type | VARCHAR | 50 | √ | null |
|
|
type of record in the batch |
|||
| encoding | VARCHAR | 50 | √ | null |
|
|
file encoding |
|||
| format | VARCHAR | 50 | √ | null |
|
|
marc format |
|||
| comments | LONGTEXT | 2147483647 | √ | null |
|
|
any comments added when the file was uploaded |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| u_import_batch_profiles__name | Must be unique | Asc | name |
Relationships
Close relationships within degrees of separation
