Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('vandelay.import_item_attr_definition_id_seq'::regclass) |
|
|
||||||||
| owner | int4 | 10 | null |
|
|
|||||||||
| name | text | 2147483647 | null |
|
|
|||||||||
| tag | text | 2147483647 | null |
|
|
|||||||||
| keep | bool | 1 | false |
|
|
|||||||||
| owning_lib | text | 2147483647 | √ | null |
|
|
||||||||
| circ_lib | text | 2147483647 | √ | null |
|
|
||||||||
| call_number | text | 2147483647 | √ | null |
|
|
||||||||
| copy_number | text | 2147483647 | √ | null |
|
|
||||||||
| status | text | 2147483647 | √ | null |
|
|
||||||||
| location | text | 2147483647 | √ | null |
|
|
||||||||
| circulate | text | 2147483647 | √ | null |
|
|
||||||||
| deposit | text | 2147483647 | √ | null |
|
|
||||||||
| deposit_amount | text | 2147483647 | √ | null |
|
|
||||||||
| ref | text | 2147483647 | √ | null |
|
|
||||||||
| holdable | text | 2147483647 | √ | null |
|
|
||||||||
| price | text | 2147483647 | √ | null |
|
|
||||||||
| barcode | text | 2147483647 | √ | null |
|
|
||||||||
| circ_modifier | text | 2147483647 | √ | null |
|
|
||||||||
| circ_as_type | text | 2147483647 | √ | null |
|
|
||||||||
| alert_message | text | 2147483647 | √ | null |
|
|
||||||||
| opac_visible | text | 2147483647 | √ | null |
|
|
||||||||
| pub_note_title | text | 2147483647 | √ | null |
|
|
||||||||
| pub_note | text | 2147483647 | √ | null |
|
|
||||||||
| priv_note_title | text | 2147483647 | √ | null |
|
|
||||||||
| priv_note | text | 2147483647 | √ | null |
|
|
||||||||
| internal_id | text | 2147483647 | √ | null |
|
|
||||||||
| stat_cat_data | text | 2147483647 | √ | null |
|
|
||||||||
| parts_data | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| import_item_attr_definition_pkey | Primary key | Asc | id |
| vand_import_item_attr_def_idx | Must be unique | Asc/Asc | owner + name |
