SchemaSpy Analysis of webco_3.9.1.public Generated by
SchemaSpy
Generated by SchemaSpy on Tue Feb 04 14:58 EST 2014
Database Type: PostgreSQL - 9.1.11 SourceForge.net


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

113 Tables and 7 Views:

Table Children Parents Columns Rows Comments
account_code 1 5 0
allocation 18 8 38 0
allocation_building_pass 3 4 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 3 1
bibliographic_record 2 31 0
bibliographic_record_configuration 25 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 1 2 0
circulation_policy 1 5 0
coalesced_deliver_to_v 3 view
dat_location 2 2 0
dat_organization 2 2 0
default_allocation_times 2 6 0
department 4 1 13 0
department_code 1 4 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 2 0
hold 3 7 0
holding 2 7 0
holding_ext 10 0
import_session 7 0
index_entry 7 0
integration_log 8 0
integration_proc 5 0
inventory_event 2 5 0
invoice 3 8 27 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
late_returns 2 view
location 16 2 35 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
notification_channel 4 0
organization 9 2 20 1
organization_credit_card_type 2 0
person 41 36 1
person_ext 26 0
person_location_signature 2 4 0
person_role 2 3 0
pir_allocation 1 3 9 0
pir_item 2 3 0
pir_person_location 2 3 0
pir_request_log 4 11 0
planq_version 1 0
pq_account_preference 3 0
pq_invoice 4 0
pq_invoice_line 6 0
pq_organization_additional_contact 3 0
project_layout 3 0
resource 13 4 39 0
resource_child 2 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 10 0
resource_sleep_queue 1 view
resource_type 9 2 15 2
resource_type_ext 11 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
service 4 0
string_map 2 2
subscription 2 1 4 0
subscription_contact 1 4 0
subscription_notification 1 4 0
task 2 2 21 0
task_group 4 0
task_parent_tcm 3 0
task_person 4 0
task_resource 3 0
task_resource_type 3 0
tax_rate 2 1 6 0
term 4 0
ticket 1 5 28 0
ticket_log 2 6 0
ticket_problem_type 2 0
ticket_remedy_type 2 0
turndown 2 7 0
wco_application 7 1
wco_authorization 2 6 1
wco_group 4 4 33 0
wco_http_event_log 11 view
wco_log 4 11 0
wco_request_log 17 0
wco_response_log 10 0
wco_station 1 4 0
wco_task_log 5 0
wco_version 1 1

Columns: 988   Rows: 11