SchemaSpy Analysis of webco_4.7.public Generated by
SchemaSpy
Generated by SchemaSpy on Thu Feb 14 09:20 CST 2019
Database Type: PostgreSQL - 9.4.15 SourceForge.net


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

126 Tables and 6 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 12 9 44 0
allocation_group 3 5 0
allocation_item_building_pass 1 5 0
allocation_log 1 7 0
allocation_person 2 4 0
allocation_repeat_rule 1 1 5 0
allocation_route 3 6 0
allocation_route_message 1 3 0
allocation_task 1 5 0
authentication 1 5 1
authset 3 13 0
authset_delegation 2 3 0
authset_entry 6 0
authset_ext 15 0
authset_path 2 4 0
auto_email 1 1 7 17
bibliographic_record 1 39 0
bibliographic_record_ext 40 0
calendar_allocation_fields 1 15 0
calendar_authentication 4 0
checkout_center 14 3 55 1
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
crestron_checkout_center_save_data 3 0
custom_property 5 12 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 38
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 3 9 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 15 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 38
migrated_resource 7 0
migrations 4 0
organization 14 2 27 1
organization_credit_card_type 2 0
patron_class 4 4 10
person 38 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_controller 9 0
resource_ext 46 0
resource_location_tcm 3 0
resource_parent 2 0
resource_schedule 3 13 0
resource_sleep_queue 1 view
resource_type 5 1 18 0
resource_type_certification 2 13 0
resource_type_certification_ext 13 0
resource_type_ext 16 0
resource_type_fallback 2 3 0
resource_wake_queue 1 view
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 59
system_role 2 4 6
system_role_capability 2 3 153
tax_rate 2 1 6 0
term 4 0
ticket 1 5 27 0
ticket_log 2 6 0
ticket_problem_type 2 0
ticket_remedy_type 2 0
turndown 3 8 0
wco_application 2 20 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,272   Rows: 409