TABLES
28
VIEWS
0
COLUMNS
288
Constraints
23
Anomalies
0
Routines
0
Database Properties
Database Type: PostgreSQL - 14.2
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| user_request_preference__t | 0 | 2 | 11 | Table | |
| check_in__t | 0 | 3 | 13 | Table | |
| loan_policy__t | 1 | 0 | 10 | Table | |
| request__t | 2 | 4 | 22 | Table | |
| patron_notice_policy | 0 | 0 | 9 | Table | |
| circulation_rules | 0 | 0 | 8 | Table | |
| fixed_due_date_schedule | 0 | 0 | 7 | Table | |
| cancellation_reason | 0 | 0 | 9 | Table | |
| request_policy | 0 | 0 | 9 | Table | |
| patron_action_session__t | 0 | 2 | 9 | Table | |
| loan | 0 | 0 | 9 | Table | |
| audit_loan__t | 0 | 0 | 8 | Table | |
| scheduled_notice__t | 0 | 4 | 12 | Table | |
| request_policy__t | 0 | 0 | 8 | Table | |
| loan_policy | 0 | 0 | 11 | Table | |
| fixed_due_date_schedule__t | 0 | 0 | 8 | Table | |
| check_in | 0 | 0 | 9 | Table | |
| staff_slips__t | 0 | 0 | 10 | Table | |
| circulation_rules__t | 0 | 0 | 7 | Table | |
| cancellation_reason__t | 1 | 0 | 10 | Table | |
| staff_slips | 0 | 0 | 9 | Table | |
| patron_action_session | 0 | 0 | 9 | Table | |
| loan__t | 8 | 8 | 27 | Table | |
| scheduled_notice | 0 | 0 | 9 | Table | |
| user_request_preference | 0 | 0 | 9 | Table | |
| patron_notice_policy__t | 0 | 0 | 9 | Table | |
| request | 0 | 0 | 10 | Table | |
| audit_loan | 0 | 0 | 7 | Table |