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 |
|
|
||||
| format | varchar | 10 | √ | null |
|
|
||||
| item_id | uuid | 2147483647 | √ | null |
|
|
||||
| title_id | uuid | 2147483647 | √ | null |
|
|
||||
| po_line_id | uuid | 2147483647 | √ | null |
|
|
||||
| location_id | uuid | 2147483647 | √ | null |
|
|
||||
| received_date | timestamptz | 35,6 | √ | null |
|
|
||||
| receiving_status | varchar | 8 | √ | null |
|
|
||||
| display_on_holding | bool | 1 | √ | null |
|
|
||||
| holding_id | uuid | 2147483647 | √ | null |
|
|
||||
| caption | varchar | 1 | √ | null |
|
|
||||
| discovery_suppress | bool | 1 | √ | null |
|
|
||||
| comment | varchar | 41 | √ | null |
|
|
||||
| receipt_date | timestamptz | 35,6 | √ | null |
|
|
||||
| supplement | bool | 1 | √ | null |
|
|
||||
| copy_number | varchar | 3 | √ | null |
|
|
||||
| enumeration | varchar | 3 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pieces__t_pkey | Primary key | Asc | __id |
| pieces__t___origin_idx | Performance | Asc | __origin |
| pieces__t___source_idx | Performance | Asc | __source |
| pieces__t___start_idx | Performance | Asc | __start |
| pieces__t_caption_idx | Performance | Asc | caption |
| pieces__t_comment_idx | Performance | Asc | comment |
| pieces__t_copy_number_idx | Performance | Asc | copy_number |
| pieces__t_discovery_suppress_idx | Performance | Asc | discovery_suppress |
| pieces__t_display_on_holding_idx | Performance | Asc | display_on_holding |
| pieces__t_enumeration_idx | Performance | Asc | enumeration |
| pieces__t_format_idx | Performance | Asc | format |
| pieces__t_holding_id_idx | Performance | Asc | holding_id |
| pieces__t_id_idx | Performance | Asc | id |
| pieces__t_item_id_idx | Performance | Asc | item_id |
| pieces__t_location_id_idx | Performance | Asc | location_id |
| pieces__t_po_line_id_idx | Performance | Asc | po_line_id |
| pieces__t_receipt_date_idx | Performance | Asc | receipt_date |
| pieces__t_received_date_idx | Performance | Asc | received_date |
| pieces__t_receiving_status_idx | Performance | Asc | receiving_status |
| pieces__t_supplement_idx | Performance | Asc | supplement |
| pieces__t_title_id_idx | Performance | Asc | title_id |
Relationships
Close relationships within degrees of separation
