Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| __id | int8 | 19 | √ | null |
|
|
||||
| __cf | bool | 1 | true |
|
|
|||||
| __start | timestamptz | 35,6 | null |
|
|
|||||
| __source | varchar | 63 | null |
|
|
|||||
| __origin | varchar | 63 | ''::character varying |
|
|
|||||
| id | uuid | 2147483647 | null |
|
|
|||||
| _version | numeric | 131089 | √ | null |
|
|
||||
| copy_number | varchar | 29 | √ | null |
|
|
||||
| instance_id | uuid | 2147483647 | √ | null |
|
|
||||
| permanent_location_id | uuid | 2147483647 | √ | null |
|
|
||||
| holdings_type_id | uuid | 2147483647 | √ | null |
|
|
||||
| call_number_type_id | uuid | 2147483647 | √ | null |
|
|
||||
| effective_location_id | uuid | 2147483647 | √ | null |
|
|
||||
| hrid | varchar | 8 | √ | null |
|
|
||||
| source_id | uuid | 2147483647 | √ | null |
|
|
||||
| call_number | varchar | 221 | √ | null |
|
|
||||
| discovery_suppress | bool | 1 | √ | null |
|
|
||||
| call_number_prefix | varchar | 19 | √ | null |
|
|
||||
| temporary_location_id | uuid | 2147483647 | √ | null |
|
|
||||
| number_of_items | varchar | 17 | √ | null |
|
|
||||
| receipt_status | varchar | 36 | √ | null |
|
|
||||
| digitization_policy | varchar | 8 | √ | null |
|
|
||||
| shelving_title | varchar | 1 | √ | null |
|
|
||||
| retention_policy | varchar | 1 | √ | null |
|
|
||||
| call_number_suffix | varchar | 23 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| holdings_record__t_pkey | Primary key | Asc | id |
| holdings_record__t___origin_idx | Performance | Asc | __origin |
| holdings_record__t___source_idx | Performance | Asc | __source |
| holdings_record__t___start_idx | Performance | Asc | __start |
| holdings_record__t__version_idx | Performance | Asc | _version |
| holdings_record__t_call_number_idx | Performance | Asc | call_number |
| holdings_record__t_call_number_prefix_idx | Performance | Asc | call_number_prefix |
| holdings_record__t_call_number_suffix_idx | Performance | Asc | call_number_suffix |
| holdings_record__t_call_number_type_id_idx | Performance | Asc | call_number_type_id |
| holdings_record__t_copy_number_idx | Performance | Asc | copy_number |
| holdings_record__t_digitization_policy_idx | Performance | Asc | digitization_policy |
| holdings_record__t_discovery_suppress_idx | Performance | Asc | discovery_suppress |
| holdings_record__t_effective_location_id_idx | Performance | Asc | effective_location_id |
| holdings_record__t_holdings_type_id_idx | Performance | Asc | holdings_type_id |
| holdings_record__t_hrid_idx | Performance | Asc | hrid |
| holdings_record__t_id_idx | Performance | Asc | id |
| holdings_record__t_instance_id_idx | Performance | Asc | instance_id |
| holdings_record__t_number_of_items_idx | Performance | Asc | number_of_items |
| holdings_record__t_permanent_location_id_idx | Performance | Asc | permanent_location_id |
| holdings_record__t_receipt_status_idx | Performance | Asc | receipt_status |
| holdings_record__t_retention_policy_idx | Performance | Asc | retention_policy |
| holdings_record__t_shelving_title_idx | Performance | Asc | shelving_title |
| holdings_record__t_source_id_idx | Performance | Asc | source_id |
| holdings_record__t_temporary_location_id_idx | Performance | Asc | temporary_location_id |
Relationships
Close relationships within degrees of separation
