Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | varchar | 36 | null |
|
|
|||||
| _version | int8 | 19 | √ | null |
|
|
||||
| call_number | varchar | 78 | √ | null |
|
|
||||
| call_number_prefix | varchar | 19 | √ | null |
|
|
||||
| call_number_suffix | varchar | 13 | √ | null |
|
|
||||
| call_number_type_id | varchar | 36 | √ | null |
|
|
||||
| copy_number | varchar | 29 | √ | null |
|
|
||||
| discovery_suppress | bool | 1 | √ | null |
|
|
||||
| effective_location_id | varchar | 36 | √ | null |
|
|
||||
| holdings_type_id | varchar | 36 | √ | null |
|
|
||||
| hrid | varchar | 8 | √ | null |
|
|
||||
| instance_id | varchar | 36 | √ | null |
|
|
||||
| number_of_items | varchar | 17 | √ | null |
|
|
||||
| permanent_location_id | varchar | 36 | √ | null |
|
|
||||
| retention_policy | varchar | 1 | √ | null |
|
|
||||
| shelving_title | varchar | 1 | √ | null |
|
|
||||
| source_id | varchar | 36 | √ | null |
|
|
||||
| temporary_location_id | varchar | 36 | √ | null |
|
|
||||
| data | json | 2147483647 | √ | null |
|
|
||||
| acquisition_method | varchar | 1 | √ | null |
|
|
||||
| ill_policy_id | varchar | 1 | √ | null |
|
|
||||
| receipt_status | varchar | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| inventory_holdings_pkey | Primary key | Asc | id |
| inventory_holdings__version_idx | Performance | Asc | _version |
| inventory_holdings_acquisition_method_idx | Performance | Asc | acquisition_method |
| inventory_holdings_call_number_idx | Performance | Asc | call_number |
| inventory_holdings_call_number_prefix_idx | Performance | Asc | call_number_prefix |
| inventory_holdings_call_number_suffix_idx | Performance | Asc | call_number_suffix |
| inventory_holdings_call_number_type_id_idx | Performance | Asc | call_number_type_id |
| inventory_holdings_copy_number_idx | Performance | Asc | copy_number |
| inventory_holdings_discovery_suppress_idx | Performance | Asc | discovery_suppress |
| inventory_holdings_effective_location_id_idx | Performance | Asc | effective_location_id |
| inventory_holdings_holdings_type_id_idx | Performance | Asc | holdings_type_id |
| inventory_holdings_hrid_idx | Performance | Asc | hrid |
| inventory_holdings_ill_policy_id_idx | Performance | Asc | ill_policy_id |
| inventory_holdings_instance_id_idx | Performance | Asc | instance_id |
| inventory_holdings_number_of_items_idx | Performance | Asc | number_of_items |
| inventory_holdings_permanent_location_id_idx | Performance | Asc | permanent_location_id |
| inventory_holdings_receipt_status_idx | Performance | Asc | receipt_status |
| inventory_holdings_retention_policy_idx | Performance | Asc | retention_policy |
| inventory_holdings_shelving_title_idx | Performance | Asc | shelving_title |
| inventory_holdings_source_id_idx | Performance | Asc | source_id |
| inventory_holdings_temporary_location_id_idx | Performance | Asc | temporary_location_id |
Relationships
Close relationships within degrees of separation
