Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('vandelay.import_item_id_seq'::regclass) |
|
|
|||||
| record | int8 | 19 | null |
|
|
||||||
| definition | int8 | 19 | null |
|
|
||||||
| import_error | text | 2147483647 | √ | null |
|
|
|||||
| error_detail | text | 2147483647 | √ | null |
|
|
|||||
| imported_as | int8 | 19 | √ | null |
|
|
|||||
| import_time | timestamptz | 35,6 | √ | null |
|
|
|||||
| owning_lib | int4 | 10 | √ | null |
|
|
|||||
| circ_lib | int4 | 10 | √ | null |
|
|
|||||
| call_number | text | 2147483647 | √ | null |
|
|
|||||
| copy_number | int4 | 10 | √ | null |
|
|
|||||
| status | int4 | 10 | √ | null |
|
|
|||||
| location | int4 | 10 | √ | null |
|
|
|||||
| circulate | bool | 1 | √ | null |
|
|
|||||
| deposit | bool | 1 | √ | null |
|
|
|||||
| deposit_amount | numeric | 8,2 | √ | null |
|
|
|||||
| ref | bool | 1 | √ | null |
|
|
|||||
| holdable | bool | 1 | √ | null |
|
|
|||||
| price | numeric | 8,2 | √ | null |
|
|
|||||
| barcode | text | 2147483647 | √ | null |
|
|
|||||
| circ_modifier | text | 2147483647 | √ | null |
|
|
|||||
| circ_as_type | text | 2147483647 | √ | null |
|
|
|||||
| alert_message | text | 2147483647 | √ | null |
|
|
|||||
| pub_note | text | 2147483647 | √ | null |
|
|
|||||
| priv_note | text | 2147483647 | √ | null |
|
|
|||||
| stat_cat_data | text | 2147483647 | √ | null |
|
|
|||||
| parts_data | text | 2147483647 | √ | null |
|
|
|||||
| opac_visible | bool | 1 | √ | null |
|
|
|||||
| internal_id | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| import_item_pkey | Primary key | Asc | id |
| import_item_record_idx | Performance | Asc | record |
