Tables


SchemaSpy Analysis of ldp

Generated on Tue Mar 29 15:20 UTC 2022

XML Representation
Insertion Order Deletion Order
TABLES 115
VIEWS 0
COLUMNS 810
Constraints 77
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 14.2

Schema public

standard public schema

Tables

Table / View Children Parents Columns Type Comments
inventory_item_note_types 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
user_departments 0 0 2 Table

https://dev.folio.org/reference/api/#mod-users
course_terms 0 0 2 Table

https://dev.folio.org/reference/api/#mod-courses
srs_records 2 2 16 Table

https://dev.folio.org/reference/api/#mod-source-record-storage
organization_addresses 0 0 2 Table

https://dev.folio.org/reference/api/#mod-organizations-storage
inventory_classification_types 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
circulation_staff_slips 0 0 6 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
feesfines_accounts 1 2 23 Table

https://dev.folio.org/reference/api/#mod-feesfines
course_courses 0 0 2 Table

https://dev.folio.org/reference/api/#mod-courses
inventory_campuses 2 1 5 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_locations 7 4 11 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
patron_blocks_user_summary 0 1 4 Table

https://dev.folio.org/reference/api/#mod-patron-blocks
organization_emails 0 0 2 Table

https://dev.folio.org/reference/api/#mod-organizations-storage
course_departments 0 0 2 Table

https://dev.folio.org/reference/api/#mod-courses
finance_group_fund_fiscal_years 0 4 6 Table

https://dev.folio.org/reference/api/#mod-finance-storage
circulation_patron_action_sessions 0 0 2 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
feesfines_lost_item_fees_policies 1 0 12 Table

https://dev.folio.org/reference/api/#mod-feesfines
inventory_electronic_access_relationships 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
po_order_invoice_relns 0 1 4 Table

https://dev.folio.org/reference/api/#mod-orders-storage
po_purchase_orders 3 2 15 Table

https://dev.folio.org/reference/api/#mod-orders-storage
inventory_identifier_types 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
organization_contacts 0 0 7 Table

https://dev.folio.org/reference/api/#mod-organizations-storage
feesfines_overdue_fines_policies 1 0 9 Table

https://dev.folio.org/reference/api/#mod-feesfines
course_processingstatuses 0 0 2 Table

https://dev.folio.org/reference/api/#mod-courses
circulation_cancellation_reasons 0 0 6 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
feesfines_waives 0 0 3 Table

https://dev.folio.org/reference/api/#mod-feesfines
inventory_instance_relationships 0 0 2 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_instance_types 1 0 5 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
circulation_request_policies 0 0 4 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
po_order_templates 0 3 15 Table

https://dev.folio.org/reference/api/#mod-orders-storage
circulation_request_preference 0 1 7 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
po_lines 2 1 24 Table

https://dev.folio.org/reference/api/#mod-orders-storage
audit_circulation_logs 0 0 9 Table

https://dev.folio.org/reference/api/#mod-audit
course_roles 0 0 2 Table

https://dev.folio.org/reference/api/#mod-courses
email_email 0 0 12 Table

https://dev.folio.org/reference/api/#mod-email
inventory_alternative_title_types 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
organization_urls 0 0 2 Table

https://dev.folio.org/reference/api/#mod-organizations-storage
inventory_loan_types 1 0 3 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_nature_of_content_terms 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_ill_policies 0 0 3 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_service_points_users 0 2 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
finance_budgets 1 2 15 Table

https://dev.folio.org/reference/api/#mod-finance-storage
user_groups 2 0 4 Table

https://dev.folio.org/reference/api/#mod-users
inventory_service_points 6 0 7 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
circulation_patron_notice_policies 0 0 5 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
feesfines_comments 0 0 6 Table

https://dev.folio.org/reference/api/#mod-feesfines
po_alerts 0 0 2 Table

https://dev.folio.org/reference/api/#mod-orders-storage
configuration_entries 4 0 9 Table

https://dev.folio.org/reference/api/#mod-configuration
inventory_holdings_types 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
acquisitions_memberships 0 0 2 Table

https://dev.folio.org/reference/api/#mod-orders-storage
organization_categories 0 0 3 Table

https://dev.folio.org/reference/api/#mod-organizations-storage
invoice_voucher_lines 0 1 5 Table

https://dev.folio.org/reference/api/#mod-invoice-storage
feesfines_owners 3 0 3 Table

https://dev.folio.org/reference/api/#mod-feesfines
po_reporting_codes 0 0 2 Table

https://dev.folio.org/reference/api/#mod-orders-storage
perm_permissions 0 0 11 Table

https://dev.folio.org/reference/api/#mod-permissions
circulation_requests 0 2 18 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
user_proxiesfor 0 2 9 Table

https://dev.folio.org/reference/api/#mod-users
perm_users 0 1 3 Table

https://dev.folio.org/reference/api/#mod-permissions
user_addresstypes 0 0 4 Table

https://dev.folio.org/reference/api/#mod-users
circulation_check_ins 0 3 9 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
inventory_instance_relationship_types 0 0 3 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
invoice_invoices 2 2 30 Table

https://dev.folio.org/reference/api/#mod-invoice-storage
acquisitions_units 0 0 2 Table

https://dev.folio.org/reference/api/#mod-orders-storage
inventory_call_number_types 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
po_pieces 1 3 11 Table

https://dev.folio.org/reference/api/#mod-orders-storage
circulation_loan_policies 1 0 6 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
inventory_contributor_name_types 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_material_types 1 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
finance_fiscal_years 4 0 8 Table

https://dev.folio.org/reference/api/#mod-finance-storage
user_users 14 1 11 Table

https://dev.folio.org/reference/api/#mod-users
course_copyrightstatuses 0 0 2 Table

https://dev.folio.org/reference/api/#mod-courses
srs_marc 0 1 2 Table

https://dev.folio.org/reference/api/#mod-source-record-storage
feesfines_transfer_criterias 0 0 2 Table

https://dev.folio.org/reference/api/#mod-feesfines
finance_fund_types 0 0 3 Table

https://dev.folio.org/reference/api/#mod-finance-storage
finance_groups 1 0 5 Table

https://dev.folio.org/reference/api/#mod-finance-storage
inventory_instance_statuses 0 0 5 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_modes_of_issuance 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_contributor_types 0 0 5 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_libraries 1 1 5 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_holdings_note_types 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
finance_ledgers 1 1 9 Table

https://dev.folio.org/reference/api/#mod-finance-storage
inventory_instance_formats 0 0 6 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
circulation_loans 1 7 23 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
finance_funds 3 1 9 Table

https://dev.folio.org/reference/api/#mod-finance-storage
circulation_scheduled_notices 0 1 7 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
feesfines_feefineactions 0 2 14 Table

https://dev.folio.org/reference/api/#mod-feesfines
inventory_instance_note_types 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_holdings 1 3 22 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
feesfines_feefines 0 1 6 Table

https://dev.folio.org/reference/api/#mod-feesfines
inventory_institutions 2 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
srs_error 0 1 3 Table

https://dev.folio.org/reference/api/#mod-orders-storage
course_reserves 0 0 2 Table

https://dev.folio.org/reference/api/#mod-courses
finance_expense_classes 0 0 4 Table

https://dev.folio.org/reference/api/#mod-finance-storage
inventory_items 0 4 33 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_statistical_codes 0 1 6 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
invoice_lines 0 1 18 Table

https://dev.folio.org/reference/api/#mod-invoice-storage
circulation_fixed_due_date_schedules 0 0 4 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
feesfines_transfers 0 0 2 Table

https://dev.folio.org/reference/api/#mod-feesfines
invoice_vouchers 1 2 19 Table

https://dev.folio.org/reference/api/#mod-invoice-storage
organization_organizations 3 0 12 Table

https://dev.folio.org/reference/api/#mod-organizations-storage
notes 0 0 7 Table

https://dev.folio.org/reference/api/#mod-notes
circulation_loan_history 0 0 4 Table

https://dev.folio.org/reference/api/#mod-circulation-storage
inventory_item_damaged_statuses 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
organization_phone_numbers 0 0 2 Table

https://dev.folio.org/reference/api/#mod-organizations-storage
course_courselistings 0 0 2 Table

https://dev.folio.org/reference/api/#mod-courses
po_receiving_history 1 4 19 Table

https://dev.folio.org/reference/api/#mod-orders-storage
organization_interfaces 0 0 8 Table

https://dev.folio.org/reference/api/#mod-organizations-storage
inventory_statistical_code_types 1 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
inventory_holdings_sources 0 0 4 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
feesfines_payments 0 1 5 Table

https://dev.folio.org/reference/api/#mod-feesfines
feesfines_refunds 0 0 3 Table

https://dev.folio.org/reference/api/#mod-feesfines
inventory_instances 1 1 15 Table

https://dev.folio.org/reference/api/#mod-inventory-storage
finance_transactions 0 2 14 Table

https://dev.folio.org/reference/api/#mod-orders-storage
feesfines_manualblocks 0 1 10 Table

https://dev.folio.org/reference/api/#mod-feesfines
course_coursetypes 0 0 2 Table

https://dev.folio.org/reference/api/#mod-courses