Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| instance_id | uuid | 2147483647 | √ | null |
|
|
||
| instance_hrid | text | 2147483647 | √ | null |
|
|
||
| holdings_id | uuid | 2147483647 | √ | null |
|
|
||
| holdings_hrid | text | 2147483647 | √ | null |
|
|
||
| relationship_id | uuid | 2147483647 | √ | null |
|
|
||
| relationship_name | text | 2147483647 | √ | null |
|
|
||
| uri | text | 2147483647 | √ | null |
|
|
||
| link_text | text | 2147483647 | √ | null |
|
|
||
| material_specification | text | 2147483647 | √ | null |
|
|
||
| public_note | text | 2147483647 | √ | null |
|
|
||
| eaccess_ordinality | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| holdings_electronic_access_eaccess_ordinality_idx | Performance | Asc | eaccess_ordinality |
| holdings_electronic_access_holdings_hrid_idx | Performance | Asc | holdings_hrid |
| holdings_electronic_access_holdings_id_idx | Performance | Asc | holdings_id |
| holdings_electronic_access_instance_hrid_idx | Performance | Asc | instance_hrid |
| holdings_electronic_access_instance_id_idx | Performance | Asc | instance_id |
| holdings_electronic_access_link_text_idx | Performance | Asc | link_text |
| holdings_electronic_access_material_specification_idx | Performance | Asc | material_specification |
| holdings_electronic_access_public_note_idx | Performance | Asc | public_note |
| holdings_electronic_access_relationship_id_idx | Performance | Asc | relationship_id |
| holdings_electronic_access_relationship_name_idx | Performance | Asc | relationship_name |
| holdings_electronic_access_uri_idx | Performance | Asc | uri |
Diagram producer might be missing
No diagrams were produced please see application output for any errors