Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| instance_id | uuid | 2147483647 | √ | null |
|
|
||
| instance_hrid | text | 2147483647 | √ | null |
|
|
||
| match_key | text | 2147483647 | √ | null |
|
|
||
| record_source | text | 2147483647 | √ | null |
|
|
||
| discovery_suppress | bool | 1 | √ | null |
|
|
||
| staff_suppress | bool | 1 | √ | null |
|
|
||
| previously_held | bool | 1 | √ | null |
|
|
||
| is_bound_with | bool | 1 | √ | null |
|
|
||
| instance_type_id | uuid | 2147483647 | √ | null |
|
|
||
| instance_type_name | varchar | 43 | √ | null |
|
|
||
| title | text | 2147483647 | √ | null |
|
|
||
| index_title | text | 2147483647 | √ | null |
|
|
||
| mode_of_issuance_id | uuid | 2147483647 | √ | null |
|
|
||
| mode_of_issuance_name | varchar | 20 | √ | null |
|
|
||
| cataloged_date | date | 13 | √ | null |
|
|
||
| created_date | date | 13 | √ | null |
|
|
||
| updated_date | date | 13 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| instance_ext_cataloged_date_idx | Performance | Asc | cataloged_date |
| instance_ext_created_date_idx | Performance | Asc | created_date |
| instance_ext_discovery_suppress_idx | Performance | Asc | discovery_suppress |
| instance_ext_instance_hrid_idx | Performance | Asc | instance_hrid |
| instance_ext_instance_id_idx | Performance | Asc | instance_id |
| instance_ext_instance_type_id_idx | Performance | Asc | instance_type_id |
| instance_ext_instance_type_name_idx | Performance | Asc | instance_type_name |
| instance_ext_is_bound_with_idx | Performance | Asc | is_bound_with |
| instance_ext_match_key_idx | Performance | Asc | match_key |
| instance_ext_mode_of_issuance_id_idx | Performance | Asc | mode_of_issuance_id |
| instance_ext_mode_of_issuance_name_idx | Performance | Asc | mode_of_issuance_name |
| instance_ext_previously_held_idx | Performance | Asc | previously_held |
| instance_ext_record_source_idx | Performance | Asc | record_source |
| instance_ext_staff_suppress_idx | Performance | Asc | staff_suppress |
| instance_ext_updated_date_idx | Performance | Asc | updated_date |
Diagram producer might be missing
No diagrams were produced please see application output for any errors