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 |
|
|
||
| holdings_statement | text | 2147483647 | √ | null |
|
|
||
| public_note | text | 2147483647 | √ | null |
|
|
||
| staff_note | text | 2147483647 | √ | null |
|
|
||
| statement_ordinality | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| holdings_statements_indexes_holdings_hrid_idx | Performance | Asc | holdings_hrid |
| holdings_statements_indexes_holdings_id_idx | Performance | Asc | holdings_id |
| holdings_statements_indexes_holdings_statement_idx | Performance | Asc | holdings_statement |
| holdings_statements_indexes_instance_hrid_idx | Performance | Asc | instance_hrid |
| holdings_statements_indexes_instance_id_idx | Performance | Asc | instance_id |
| holdings_statements_indexes_public_note_idx | Performance | Asc | public_note |
| holdings_statements_indexes_staff_note_idx | Performance | Asc | staff_note |
| holdings_statements_indexes_statement_ordinality_idx | Performance | Asc | statement_ordinality |
Diagram producer might be missing
No diagrams were produced please see application output for any errors