Tables


SchemaSpy Analysis of folio

Generated on Wed Jun 01 04:21 UTC 2022

XML Representation
Insertion Order Deletion Order
TABLES 77
VIEWS 0
COLUMNS 744
Constraints 31
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 14.2

Tables

Table / View Children Parents Columns Type Comments
holdings_type__t 1 0 8 Table
holdings_records_source__t 1 0 8 Table
folio_marc_export_log 0 0 11 Table
statistical_code__t 0 1 10 Table
instance_relationship_type__t 0 0 7 Table
locinstitution__t 2 0 8 Table
statistical_code_type__t 1 0 8 Table
alternative_title_type__t 0 0 8 Table
item_note_type 0 0 9 Table
call_number_type 0 0 9 Table
service_point_user__t 0 2 8 Table
loan_type 0 0 9 Table
classification_type 0 0 9 Table
holdings_type 0 0 9 Table
electronic_access_relationship__t 0 0 8 Table
audit_item__t 0 0 8 Table
holdings_note_type 0 0 9 Table
instance_status 0 0 9 Table
nature_of_content_term__t 0 0 8 Table
audit_holdings_record__t 0 0 8 Table
audit_item 0 0 7 Table
instance_type__t 1 0 9 Table
location__t 10 4 15 Table
statistical_code 0 0 10 Table
identifier_type 0 0 9 Table
material_type__t 1 0 8 Table
loccampus__t 2 1 9 Table
holdings_record__t 1 7 25 Table
instance_format__t 0 0 10 Table
instance_note_type__t 0 0 8 Table
instance 0 0 12 Table
reindex_job__t 0 0 9 Table
reindex_job 0 0 7 Table
holdings_note_type__t 0 0 8 Table
audit_instance__t 0 0 8 Table
item 0 0 16 Table
mode_of_issuance 0 0 9 Table
instance__t 5 3 19 Table
service_point 0 0 9 Table
nature_of_content_term 0 0 9 Table
alternative_title_type 0 0 9 Table
hrid_settings__t 0 0 7 Table
instance_format 0 0 7 Table
audit_holdings_record 0 0 7 Table
locinstitution 0 0 9 Table
item_damaged_status__t 1 0 8 Table
electronic_access_relationship 0 0 9 Table
instance_type 0 0 7 Table
item_damaged_status 0 0 9 Table
location 0 0 12 Table
mode_of_issuance__t 1 0 8 Table
contributor_name_type__t 0 0 8 Table
contributor_type 0 0 7 Table
holdings_records_source 0 0 9 Table
service_point_user 0 0 10 Table
contributor_type__t 0 0 9 Table
material_type 0 0 9 Table
loclibrary__t 1 1 9 Table
preceding_succeeding_title 0 0 11 Table
preceding_succeeding_title__t 0 2 9 Table
contributor_name_type 0 0 9 Table
item_note_type__t 0 0 8 Table
instance_status__t 1 0 9 Table
loccampus 0 0 10 Table
classification_type__t 0 0 8 Table
audit_instance 0 0 7 Table
statistical_code_type 0 0 9 Table
identifier_type__t 1 0 8 Table
item__t 0 10 37 Table
service_point__t 9 0 11 Table
loclibrary 0 0 10 Table
call_number_type__t 2 0 8 Table
loan_type__t 2 0 7 Table
hrid_settings 0 0 8 Table
holdings_record 0 0 17 Table
instance_note_type 0 0 9 Table
instance_relationship_type 0 0 9 Table