TABLES
22
VIEWS
0
COLUMNS
205
Constraints
14
Anomalies
27
Routines
0
Database Properties
Database Type: PostgreSQL - 14.2
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| item_claimed_returned_event | 0 | 1 | 9 | Table | |
| item_checked_in_event | 0 | 1 | 9 | Table | |
| patron_block_conditions | 0 | 1 | 9 | Table | |
| item_checked_out_event | 0 | 1 | 9 | Table | |
| user_summary | 0 | 1 | 9 | Table | |
| item_declared_lost_event | 0 | 1 | 9 | Table | |
| synchronization_jobs__t | 0 | 2 | 13 | Table | |
| loan_due_date_changed_event | 0 | 1 | 9 | Table | |
| item_declared_lost_event__t | 0 | 3 | 8 | Table | |
| loan_due_date_changed_event__t | 0 | 3 | 10 | Table | |
| item_aged_to_lost_event__t | 0 | 3 | 8 | Table | |
| user_summary__t | 0 | 2 | 8 | Table | |
| fee_fine_balance_changed_event | 0 | 1 | 9 | Table | |
| patron_block_limits__t | 0 | 3 | 9 | Table | |
| patron_block_limits | 0 | 1 | 10 | Table | |
| item_aged_to_lost_event | 0 | 1 | 9 | Table | |
| item_checked_in_event__t | 0 | 3 | 9 | Table | |
| item_checked_out_event__t | 0 | 3 | 9 | Table | |
| item_claimed_returned_event__t | 0 | 3 | 8 | Table | |
| patron_block_conditions__t | 28 | 0 | 12 | Table | |
| fee_fine_balance_changed_event__t | 0 | 5 | 11 | Table | |
| synchronization_jobs | 0 | 1 | 9 | Table |