Tables


SchemaSpy Analysis of folio

Generated on Wed Jun 01 04:21 UTC 2022

XML Representation
Insertion Order Deletion Order
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