SchemaSpy Analysis of webco_4.4.1.public Generated by
SchemaSpy
Generated by SchemaSpy on Fri Mar 24 10:48 CDT 2017
Database Type: PostgreSQL - 9.4.11 SourceForge.net


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

105 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 43 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 4 1
authset 2 3 4 1
authset_authorization 2 3 0
authset_checkout_center 2 3 1
auto_email 1 1 7 16
bibliographic_record 1 39 0
bibliographic_record_ext 40 0
calendar_allocation_fields 1 15 0
calendar_authentication 4 0
checkout_center 15 2 49 1
checkout_center_auto_email 2 7 0
checkout_center_pir_pickup_option 1 3 0
checkout_center_schedule 2 2 8 0
checkout_center_schedule_node 1 6 0
circulation_policy 1 6 0
coalesced_deliver_to_v 3 view
department 4 1 15 0
department_code 1 4 0
department_ext 16 0
email_template 2 8 0
file_attachment 1 8 0
group_authorization 5 6 0
group_ext 16 0
group_member 2 2 6 0
group_member_ext 6 0
group_resource_type 2 3 0
group_set 1 1 0
group_set_member 2 3 0
hold 3 9 0
holding 2 7 0
import_session 7 0
integration_log 8 0
inventory_event 2 5 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 16 1
ldap_rule 2 8 1
message_type 4 4 35
message_type_entity 1 5 62
operator_authorization 1 2 53
operator_role 1 2 5
organization 11 1 26 1
organization_credit_card_type 2 0
patron_class 4 4 10
person 38 1 37 6
person_checkout_center_signature 2 4 0
person_ext 27 0
pir_auth_ext 9 0
pir_person_checkout_center 2 3 0
resource 11 5 48 0
resource_container_tcm 3 0
resource_controller 9 0
resource_ext 43 0
resource_location_tcm 3 0
resource_parent 2 0
resource_schedule 3 13 0
resource_sleep_queue 1 view
resource_type 5 2 18 0
resource_type_ext 12 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 1 11 0
scheduled_message_type 1 1 11 6
string_map 2 2
subscription 2 1 4 0
subscription_contact 1 4 0
subscription_notification 1 4 0
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 16 1
wco_features 2 1
wco_group 5 4 33 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,046   Rows: 205