Tables


SchemaSpy Analysis of webco_8.0

Generated on Tue Jan 14 13:35 CST 2020

XML Representation
Insertion Order Deletion Order
TABLES 151
VIEWS 2
COLUMNS 1489
Constraints 239
Anomalies 9
Routines 20

Database Properties

Database Type: PostgreSQL - 9.6.15

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
authset_entry 0 0 6 0 Table
file_attachment 0 1 9 0 Table
resource_type_certification 0 2 12 0 Table
person_role_capability 0 2 3 0 Table
patron_custom_data 0 3 5 0 Table
bibliographic_record 1 0 39 0 Table
patron_class 4 0 4 10 Table
allocation 12 9 39 0 Table
calendar_authentication 0 0 4 0 Table
custom_property_strings 0 1 3 0 Table
custom_property_money 0 1 3 0 Table
allocation_repeat_rule 1 1 5 0 Table
system_role 3 0 4 6 Table
task_type 2 1 9 4 Table
resource_ext 0 0 46 0 Table
wco_application 0 8 40 1 Table
migrations 0 0 4 0 Table
sched_staffed_location 3 1 8 0 Table
person 43 1 36 6 Table
wco_version 0 0 1 1 Table
session_client_info 0 0 4 0 Table
ticket_type 4 0 2 4 Table
department 4 1 15 0 Table
sched_employee 0 2 5 0 Table
scheduled_message_type 0 1 11 8 Table
section_ext 0 0 17 0 Table
sched_staff_availability 0 1 5 0 Table
allocation_group 0 3 5 0 Table
department_code 0 1 4 0 Table
resource_type 8 1 18 0 Table
integration_log 0 0 8 0 Table
turndown 0 3 8 0 Table
string_map 0 0 2 2 Table
model_schedule 2 0 6 0 Table
account_debit 0 4 8 0 Table
allocation_item_building_pass 0 1 5 0 Table
calendar 2 0 5 0 Table
property_sheet_config 0 0 8 52 Table
rrt_bundle 0 0 3 0 Table
rtype_tree_tcm 0 0 3 0 Table
inventory_selector 0 5 16 0 Table
maintenance_schedule 1 9 17 0 Table
location 1 3 14 0 Table
query_feed_config 0 0 6 0 Table
sched_scheduling_group_member 0 2 3 0 Table
circulation_policy 0 1 6 0 Table
email_template 1 2 7 42 Table
resource_location_tcm 0 0 3 0 Table
agreement_form_config 1 1 6 0 Table
wco_group 0 2 18 0 Table
task_profile_task_type 0 2 3 7 Table
pir_auth_ext 0 0 9 0 Table
maintenance_event 0 4 12 0 Table
organization 26 2 26 1 Table
allocation_accompanying_person 0 2 3 0 Table
model_schedule_node 0 1 4 0 Table
invoice_line 2 4 18 0 Table
ticket_assignment_rule 0 6 10 0 Table
sched_staff 4 2 4 0 Table
account_credit 0 3 7 0 Table
resource 18 6 50 0 Table
email_template_set 3 1 4 0 Table
wco_features 0 0 2 2 Table
calendar_layer 1 1 5 0 Table
patron_portal_property 0 2 7 0 Table
bibliographic_record_ext 0 0 40 0 Table
person_ext 0 0 27 0 Table
resource_schedule 1 5 16 0 Table
section_member 0 2 8 0 Table
subscription 2 1 4 0 Table
custom_property_timestamps 0 1 3 0 Table
maintenance_type 1 8 16 0 Table
section_member_ext 0 0 8 0 Table
migrated_resource 0 0 7 0 Table
person_checkout_center_signature 0 2 4 0 Table
system_role_capability 0 2 3 159 Table
ticket 2 13 27 0 Table
calendar_allocation_fields 0 1 14 0 Table
holding 0 2 6 0 Table
ticket_resolution 2 0 2 6 Table
circulation_record 0 1 6 0 Table
scheduled_message_history 0 0 6 0 Table
authset_path 0 2 4 0 Table
sched_scheduling_group 4 1 4 0 Table
checkout_center_schedule 2 2 8 0 Table
wco_station 0 1 4 0 Table
checkout_center_schedule_node 0 1 7 0 Table
account 4 2 8 0 Table
ticket_priority 4 0 3 5 Table
inventory 3 1 20 1 Table
person_role 2 3 4 1 Table
email_template_set_template 0 3 4 0 Table
hold 0 4 10 0 Table
ldap_profile 1 0 17 1 Table
person_role_checkout_center 0 2 3 1 Table
task 1 4 11 0 Table
resource_type_ext 0 0 16 0 Table
message_type 4 0 7 43 Table
subscription_contact 0 1 4 0 Table
ticket_severity 4 0 3 7 Table
allocation_log 0 1 7 0 Table
invoice 3 6 33 0 Table
system_capability 2 0 3 62 Table
authset_ext 0 0 16 0 Table
custom_property_integers 0 1 3 0 Table
ticket_problem_type 5 0 2 3 Table
ticket_remedy_type 4 0 2 3 Table
ticket_expense_type 1 0 2 3 Table
auto_email 1 1 6 17 Table
wco_task_log 0 0 6 0 Table
account_code_ext 0 0 8 0 Table
organization_credit_card_type 0 0 2 0 Table
bundle_path 0 0 4 0 Table
import_session 0 0 7 0 Table
entity_auto_email 0 1 8 0 Table
custom_property 6 0 16 0 Table
invoice_line_tax_rate 0 2 4 0 Table
sched_staff_assignment 0 5 9 0 Table
authset_delegation 0 2 3 0 Table
resource_container_tcm 0 0 3 0 Table
type_allocation_usage_data 0 3 3 0 Table
ticket_work_type 1 0 2 4 Table
authentication 0 1 7 1 Table
sched_staffing_limit 0 1 4 0 Table
resource_type_fallback 0 2 3 0 Table
authset 3 0 13 0 Table
custom_property_booleans 0 1 3 0 Table
inventory_note 1 4 9 0 Table
resource_parent 0 0 2 0 Table
group_ext 0 0 17 0 Table
scheduled_message_rule 0 0 12 0 Table
department_ext 0 0 16 0 Table
find_config 0 0 9 57 Table
ldap_rule 0 2 9 1 Table
task_profile 2 1 5 4 Table
task_person 0 2 3 0 Table
wco_log 0 4 11 0 Table
checkout_center_pir_pickup_option 0 1 3 0 Table
wco_request_log 0 0 24 0 Table
checkout_center 20 3 66 1 Table
tax_rate 0 1 6 0 Table
subscription_notification 0 1 4 0 Table
ticket_log 0 4 11 0 Table
calendar_period 0 3 8 0 Table
vendor 3 1 13 0 Table
checkout_center_default_task_profile 0 2 3 0 Table
invoice_tax_rate 1 1 5 0 Table
sched_shift 1 1 13 0 Table
resource_type_certification_ext 0 0 12 0 Table
section 1 0 18 0 Table
inventory_item 0 6 10 0 Table
late_returns 0 0 2 0 View
coalesced_deliver_to_v 0 0 3 0 View