SchemaSpy Analysis of webco_3.5.5.public Generated by
SchemaSpy
Generated by SchemaSpy on Mon Mar 15 14:58 EDT 2010
Database Type: PostgreSQL - 8.3.9 SourceForge.net

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

95 Tables and 8 Views:

Table Children Parents Columns Rows Comments
account_code 1 5 0
allocation 18 7 33 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
department 4 1 13 0
department_code 1 4 0
freelancer_person_location 2 3 0
group_authorization 3 5 0
group_ext 15 0
group_member 2 6 0
group_member_ext 6 0
group_resource_type 2 3 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_balance 2 view
invoice_charges 2 view
invoice_line 4 15 0
invoice_payments 2 view
invoice_tax 2 view
late_returns 2 view
location 8 2 27 1
mail_event 1 4 0
notification_channel 4 0
organization 7 2 21 1
person 34 37 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 22 0
pq_organization_additional_contact 3 0
project_layout 3 0
resource 12 4 36 1
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 16 2
resource_type_ext 10 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 1 1 4 0
subscription_watch 1 6 0
task 2 2 21 0
task_changes 26 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
watch_notification 4 0
wco_application 7 1
wco_authorization 2 6 1
wco_group 4 4 34 0
wco_invoice 2 8 26 0
wco_log 3 10 0
wco_station 1 4 0
wco_version 1 1

Columns: 873   Rows: 10