Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | varchar | 36 | null |
|
|
|||||
| _version | int8 | 19 | √ | null |
|
|
||||
| cataloged_date | varchar | 10 | √ | null |
|
|
||||
| discovery_suppress | bool | 1 | √ | null |
|
|
||||
| hrid | varchar | 8 | √ | null |
|
|
||||
| index_title | varchar | 5674 | √ | null |
|
|
||||
| instance_type_id | varchar | 36 | √ | null |
|
|
||||
| mode_of_issuance_id | varchar | 36 | √ | null |
|
|
||||
| previously_held | bool | 1 | √ | null |
|
|
||||
| source | varchar | 5 | √ | null |
|
|
||||
| staff_suppress | bool | 1 | √ | null |
|
|
||||
| status_id | varchar | 36 | √ | null |
|
|
||||
| status_updated_date | timestamptz | 35,6 | √ | null |
|
|
||||
| title | varchar | 5676 | √ | null |
|
|
||||
| data | json | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| inventory_instances_pkey | Primary key | Asc | id |
| inventory_instances__version_idx | Performance | Asc | _version |
| inventory_instances_cataloged_date_idx | Performance | Asc | cataloged_date |
| inventory_instances_discovery_suppress_idx | Performance | Asc | discovery_suppress |
| inventory_instances_hrid_idx | Performance | Asc | hrid |
| inventory_instances_instance_type_id_idx | Performance | Asc | instance_type_id |
| inventory_instances_mode_of_issuance_id_idx | Performance | Asc | mode_of_issuance_id |
| inventory_instances_previously_held_idx | Performance | Asc | previously_held |
| inventory_instances_source_idx | Performance | Asc | source |
| inventory_instances_staff_suppress_idx | Performance | Asc | staff_suppress |
| inventory_instances_status_id_idx | Performance | Asc | status_id |
| inventory_instances_status_updated_date_idx | Performance | Asc | status_updated_date |
Relationships
Close relationships within degrees of separation
