Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| campus_id | uuid | 2147483647 | √ | null |
|
|
||
| campus_name | varchar | 9 | √ | null |
|
|
||
| location_id | uuid | 2147483647 | √ | null |
|
|
||
| location_name | varchar | 79 | √ | null |
|
|
||
| discovery_display_name | varchar | 84 | √ | null |
|
|
||
| library_id | uuid | 2147483647 | √ | null |
|
|
||
| library_name | varchar | 29 | √ | null |
|
|
||
| institution_id | uuid | 2147483647 | √ | null |
|
|
||
| institution_name | varchar | 21 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| locations_libraries_campus_id_idx | Performance | Asc | campus_id |
| locations_libraries_campus_name_idx | Performance | Asc | campus_name |
| locations_libraries_discovery_display_name_idx | Performance | Asc | discovery_display_name |
| locations_libraries_institution_id_idx | Performance | Asc | institution_id |
| locations_libraries_institution_name_idx | Performance | Asc | institution_name |
| locations_libraries_library_id_idx | Performance | Asc | library_id |
| locations_libraries_library_name_idx | Performance | Asc | library_name |
| locations_libraries_location_id_idx | Performance | Asc | location_id |
| locations_libraries_location_name_idx | Performance | Asc | location_name |
Diagram producer might be missing
No diagrams were produced please see application output for any errors