| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| import_record_id | INT | 10 | √ | null |
|
|
||||||||||
| import_batch_id | INT | 10 | null |
|
|
|||||||||||
| 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 |
|
|
