TABLES
8
VIEWS
13
COLUMNS
201
Constraints
17
Anomalies
0
Routines
9
Database Properties
Database Type: PostgreSQL - 15.10 (Ubuntu 15.10-1.pgdg24.04+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| hold_request_record | 0 | 0 | 4 | 265 | Table | |
| template_folder | 2 | 3 | 8 | -1 | Table | |
| report_folder | 2 | 3 | 8 | -1 | Table | |
| materialized_simple_record | 5 | 0 | 11 | 344 | Table | |
| output_folder | 2 | 3 | 8 | -1 | Table | |
| template | 1 | 2 | 7 | -1 | Table | |
| schedule | 0 | 3 | 16 | -1 | Table | |
| report | 1 | 3 | 10 | -1 | Table | |
| completed_reports | 0 | 0 | 16 | 0 | View | |
| asset_call_number_dewey | 0 | 0 | 6 | 0 | View | |
| old_super_simple_record | 0 | 1 | 11 | 0 | View | |
| overdue_circs | 0 | 1 | 34 | 0 | View | |
| super_simple_record | 0 | 1 | 11 | 0 | View | |
| currently_running | 0 | 0 | 5 | 0 | View | |
| xact_paid_totals | 0 | 0 | 4 | 0 | View | |
| simple_record | 0 | 1 | 22 | 0 | View | |
| xact_billing_totals | 0 | 0 | 4 | 0 | View | |
| circ_type | 0 | 1 | 2 | 0 | View | |
| pending_reports | 0 | 0 | 5 | 0 | View | |
| demographic | 0 | 0 | 4 | 0 | View | |
| overdue_reports | 0 | 0 | 5 | 0 | View |