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 |