Tables


SchemaSpy Analysis of folio

Generated on Wed Jun 01 04:21 UTC 2022

XML Representation
Insertion Order Deletion Order
TABLES 35
VIEWS 0
COLUMNS 442
Constraints 0
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 14.2

Tables

Table / View Children Parents Columns Type Comments
holdings_statements_supplements 0 0 8 Table
po_lines_phys_mat_type 0 0 3 Table
invoice_adjustments_in_addition_to 0 0 6 Table
loans_renewal_count 0 0 4 Table
po_lines_details_subscription 0 0 4 Table
finance_transaction_invoices 0 0 30 Table
instance_languages 0 0 4 Table
holdings_notes 0 0 12 Table
po_ongoing 0 0 6 Table
po_lines_eresource 0 0 16 Table
loans_renewal_dates 0 0 6 Table
po_lines_physical 0 0 11 Table
holdings_statements 0 0 8 Table
instance_formats 0 0 7 Table
instance_alternative_titles 0 0 6 Table
instance_statistical_codes 0 0 8 Table
po_lines_tags 0 0 3 Table
po_lines_er_mat_type 0 0 3 Table
holdings_statistical_codes 0 0 10 Table
agreements_subscription_agreement 0 0 18 Table
po_line_fund_distribution_transactions 0 0 31 Table
instance_ext 0 0 17 Table
finance_transaction_purchase_order 0 0 23 Table
locations_libraries 0 0 9 Table
instance_electronic_access 0 0 9 Table
instance_contributors 0 0 10 Table
instance_nature_content 0 0 6 Table
agreements_subscription_agreement_entitlement 0 0 17 Table
invoice_voucher_lines_fund_distributions 0 0 16 Table
instance_editions 0 0 4 Table
invoice_adjustments_ext 0 0 12 Table
loans_items 0 0 53 Table
item_ext 0 0 43 Table
holdings_statements_indexes 0 0 8 Table
holdings_electronic_access 0 0 11 Table