TABLES
16
VIEWS
7
COLUMNS
122
Constraints
22
Anomalies
1
Routines
56
Database Properties
Database Type: PostgreSQL - 15.10 (Ubuntu 15.10-1.pgdg24.04+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| control_set_bib_field | 1 | 1 | 3 | -1 | Table | |
| heading_field_norm_map | 0 | 2 | 5 | -1 | Table | |
| authority_linking | 0 | 3 | 4 | -1 | Table | |
| browse_axis | 1 | 1 | 4 | -1 | Table | |
| control_set | 3 | 0 | 3 | -1 | Table | |
| browse_axis_authority_field_map | 0 | 2 | 3 | -1 | Table | |
| full_rec | 0 | 0 | 8 | 6247 | Table | |
| thesaurus | 0 | 1 | 6 | 396 | Table | |
| bib_linking | 0 | 2 | 3 | 245 | Table | |
| record_entry | 8 | 1 | 14 | 195 | Table | |
| control_set_bib_field_metabib_field_map | 0 | 2 | 3 | -1 | Table | |
| rec_descriptor | 0 | 0 | 5 | 195 | Table | |
| record_note | 0 | 1 | 7 | -1 | Table | |
| simple_heading | 1 | 2 | 7 | 1108 | Table | |
| heading_field | 2 | 1 | 11 | -1 | Table | |
| control_set_authority_field | 5 | 3 | 12 | 48 | Table | |
| control_set_auth_field_metabib_field_map_refs_only | 0 | 0 | 2 | 0 | View | metabib fields for NON-main entry auth fields |
| control_set_auth_field_metabib_field_map_main | 0 | 0 | 2 | 0 | View | metabib fields for main entry auth fields |
| control_set_auth_field_metabib_field_map_blind_refs | 0 | 0 | 2 | 0 | View | metabib fields for all auth fields that can’t be linked to other records |
| control_set_auth_field_metabib_field_map_refs | 0 | 0 | 2 | 0 | View | metabib fields for all auth fields |
| tracing_links | 0 | 0 | 12 | 0 | View | |
| control_set_auth_field_metabib_field_map_blind_refs_only | 0 | 0 | 2 | 0 | View | metabib fields for NON-main entry auth fields that can’t be linked to other records |
| control_set_auth_field_metabib_field_map_blind_main | 0 | 0 | 2 | 0 | View | metabib fields for main entry auth fields that can’t be linked to other records |