SchemaSpy Analysis of webco_3.6.1.public Generated by
SchemaSpy
Generated by SchemaSpy on Wed May 11 15:14 EDT 2011
Database Type: PostgreSQL - 8.3.14 SourceForge.net


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

100 Tables and 7 Views:

Table Children Parents Columns Rows Comments
account_code 1 5 0
allocation 18 7 34 0
allocation_building_pass 3 4 0
allocation_contents 1 8 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_item 1 7 0
allocation_log 1 6 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_staffing 2 6 0
allocation_task 1 5 0
authentication 1 3 1
bibliographic_record 2 26 0
bibliographic_record_configuration 25 0
bibliographic_record_ext 27 0
bibliographic_record_helix 1 4 0
bibliographic_record_helix_ext 3 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
freelancer_person_location 2 3 0
group_authorization 3 5 0
group_ext 16 0
group_member 2 6 0
group_member_ext 6 0
group_resource_type 2 3 0
group_set 2 0
hold 3 8 0
holding 2 7 0
holding_ext 10 0
import_session 1 0
index_entry 7 0
integration_log 8 0
integration_proc 5 0
invoice 2 8 27 0
invoice_charges 2 view
invoice_line 4 15 0
invoice_payments 2 view
invoice_tax 2 view
late_returns 2 view
location 10 2 31 1
location_schedule 2 2 8 0
location_schedule_node 1 6 0
mail_event 1 4 0
notification_channel 4 0
organization 8 2 21 1
organization_credit_card_type 2 0
person 34 36 1
person_ext 26 0
person_role 2 3 0
pir_allocation 1 3 9 0
pir_item 2 3 0
pir_person_location 2 3 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 12 4 35 0
resource_child 2 0
resource_container_tcm 3 0
resource_controller 9 0
resource_ext 37 0
resource_location_tcm 3 0
resource_parent 2 0
resource_schedule 3 9 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 0
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
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_log 3 10 0
wco_station 1 4 0
wco_version 1 1

Columns: 853   Rows: 9