SchemaSpy Analysis of webco_5.0.public Generated by
SchemaSpy
Generated by SchemaSpy on Thu Feb 14 09:10 CST 2019
Database Type: PostgreSQL - 9.4.15 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

128 Tables and 4 Views:

Table Children Parents Columns Rows Comments
account_code 1 7 0
account_code_ext 8 0
agreement_form_config 1 1 6 0
allocation 11 10 42 0
allocation_accompanying_person 2 3 0
allocation_group 3 5 0
allocation_item_building_pass 1 5 0
allocation_log 1 7 0
allocation_repeat_rule 1 1 5 0
authentication 1 7 1
authset 3 13 0
authset_delegation 2 3 0
authset_entry 6 0
authset_ext 16 0
authset_path 2 4 0
auto_email 1 1 6 17
bibliographic_record 1 39 0
bibliographic_record_ext 40 0
bundle_path 4 0
calendar_allocation_fields 1 14 0
calendar_authentication 4 0
checkout_center 16 3 59 1
checkout_center_default_task_profile 2 3 0
checkout_center_pir_pickup_option 1 3 0
checkout_center_schedule 2 2 8 0
checkout_center_schedule_node 1 7 0
circulation_policy 1 6 0
coalesced_deliver_to_v 3 view
custom_property 5 13 0
custom_property_booleans 1 3 0
custom_property_integers 1 3 0
custom_property_money 1 3 0
custom_property_strings 1 3 0
custom_property_timestamps 1 3 0
department 6 1 15 0
department_code 1 4 0
department_ext 16 0
email_serialization 5 6
email_template 1 2 7 39
email_template_set 3 1 4 0
email_template_set_template 3 4 0
entity_auto_email 1 8 0
file_attachment 1 8 0
find_config 9 54
group_ext 17 0
hold 4 10 0
holding 2 6 0
import_session 7 0
integration_log 8 0
inventory 3 1 20 1
inventory_item 6 10 0
inventory_note 1 4 9 0
inventory_selector 5 16 0
invoice 4 8 29 0
invoice_charges 2 view
invoice_line 1 4 14 0
invoice_line_tax_rate 2 4 0
invoice_payments 2 view
invoice_tax_rate 2 3 0
invoices_pending_export 1 2 0
late_returns 2 view
ldap_profile 1 17 1
ldap_rule 2 9 1
message_type 4 7 40
migrated_resource 7 0
migrations 4 0
organization 17 2 28 1
organization_credit_card_type 2 0
patron_class 4 4 10
person 39 1 39 6
person_checkout_center_signature 2 4 0
person_ext 27 0
person_role 2 3 4 1
person_role_capability 2 3 0
person_role_checkout_center 2 3 1
pir_auth_ext 9 0
resource 14 6 53 0
resource_container_tcm 3 0
resource_ext 46 0
resource_location_tcm 3 0
resource_parent 2 0
resource_schedule 4 14 0
resource_type 5 1 18 0
resource_type_certification 2 12 0
resource_type_certification_ext 12 0
resource_type_ext 16 0
resource_type_fallback 2 3 0
rrt_bundle 3 0
rtype_tree_tcm 3 0
sched_scheduling_group 3 1 4 0
sched_scheduling_group_member 2 3 0
sched_shift 1 1 13 0
sched_staff 4 2 4 0
sched_staff_assignment 5 9 0
sched_staff_availability 1 5 0
sched_staffed_location 3 1 8 0
sched_staffing_limit 1 4 0
scheduled_message_history 6 0
scheduled_message_rule 12 0
scheduled_message_type 1 11 8
section 1 18 0
section_ext 17 0
section_member 2 8 0
section_member_ext 8 0
session_client_info 4 0
string_map 2 2
subscription 2 1 4 0
subscription_contact 1 4 0
subscription_notification 1 4 0
system_capability 2 3 61
system_role 2 4 6
system_role_capability 2 3 159
task 1 3 9 0
task_person 2 3 0
task_profile 2 1 5 4
task_profile_task_type 2 3 7
task_type 2 1 9 4
tax_rate 2 1 6 0
term 4 0
ticket 1 6 30 0
ticket_log 2 6 0
ticket_problem_type 2 0
ticket_remedy_type 2 0
turndown 3 8 0
wco_application 2 23 1
wco_features 2 2
wco_group 2 18 0
wco_log 4 11 0
wco_request_log 24 0
wco_station 1 4 0
wco_task_log 6 0
wco_version 1 1

Columns: 1,291   Rows: 435