SchemaSpy Analysis of webco_4.1.0.public Generated by
SchemaSpy
Generated by SchemaSpy on Wed Nov 05 15:04 EST 2014
Database Type: PostgreSQL - 9.1.14 SourceForge.net


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

109 Tables and 7 Views:

Table Children Parents Columns Rows Comments
account_code 1 7 0
account_code_ext 8 0
agreement_form_config 1 6 0
allocation 16 8 40 0
allocation_freelancer 2 2 6 0
allocation_freelancer_assigned 2 3 0
allocation_freelancer_role 2 3 0
allocation_group 3 5 0
allocation_log 1 6 0
allocation_person 2 4 0
allocation_reminder_interval 1 1 4 0
allocation_repeat_rule 1 1 5 0
allocation_route 3 6 0
allocation_route_message 1 3 0
allocation_staffing 2 6 0
allocation_task 1 5 0
authentication 1 6 1
authset 2 3 4 1
authset_authorization 2 3 0
authset_location 2 3 1
bibliographic_record 2 31 0
bibliographic_record_ext 32 0
bibliographic_record_helix 1 4 0
bibliographic_record_helix_ext 3 0
calendar_allocation_fields 1 14 0
calendar_authentication 4 0
circulation_policy 1 5 0
coalesced_deliver_to_v 3 view
dat_location 2 3 0
dat_organization 2 3 0
default_allocation_times 2 6 0
department 4 1 15 0
department_code 1 4 0
department_ext 16 0
file_attachment 1 8 0
freelancer_person_location 2 3 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
location 17 2 38 1
location_auto_email 1 14 0
location_pir_pickup_option 1 3 0
location_schedule 2 2 8 0
location_schedule_node 1 6 0
mail_event 2 5 0
operator_authorization 1 2 54
operator_role 1 2 5
organization 10 2 22 1
organization_credit_card_type 2 0
person 41 37 1
person_ext 26 0
person_location_signature 2 4 0
person_role 2 3 0
pir_auth_ext 9 0
pir_person_location 2 3 0
pir_request_log 4 11 0
resource 11 4 39 0
resource_container_tcm 3 0
resource_controller 9 0
resource_ext 39 0
resource_location_tcm 3 0
resource_parent 2 0
resource_schedule 3 11 0
resource_sleep_queue 1 view
resource_type 8 2 16 2
resource_type_ext 12 0
resource_type_fallback 2 3 0
resource_wake_queue 1 view
role 4 4 0
rrt_bundle 3 0
rtype_tree_tcm 3 0
sched_published_shift 1 3 8 0
sched_scheduling_group 3 1 4 0
sched_scheduling_group_member 2 3 0
sched_staff 4 2 4 0
sched_staff_availability 1 5 0
sched_staffed_location 4 1 8 0
sched_staffing_limit 1 4 0
sched_unpublished_shift 4 10 0
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 2 7 0
wco_application 6 1
wco_group 5 4 33 0
wco_http_event_log 14 view
wco_log 4 11 0
wco_request_log 18 0
wco_response_log 10 0
wco_station 1 4 0
wco_task_log 5 0
wco_version 1 1

Columns: 982   Rows: 71