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
