SchemaSpy Analysis of george.public Generated by
SchemaSpy
Generated by SchemaSpy on Tue Jul 14 15:21 GMT-03:00 2009
Database Type: PostgreSQL - 8.3.7 SourceForge.net

Please support this project

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

92 Tables:

Table Children Parents Rows Comments
address 4 12
bank 1 2 0
bank_account 3 2 1
base_sellable_info 1 2 15
branch_station 5 3 2
branch_synchronization 1 0
calls 4 0
card_installment_settings 3 2 0
card_installments_provider_details 1 0
card_installments_store_details 1 0
cfop_data 5 2 3
check_data 4 1
city_location 2 2 10
commission 5 1
commission_source 4 7
credit_card_data 4 0
credit_card_details 1 0
credit_provider_group_data 5 0
debit_card_details 0
delivery_item 4 0
device_constant 3 0
device_settings 1 3 0
employee_role 2 2 6
employee_role_history 4 5
fiscal_book_entry 6 4
fiscal_day_history 1 3 0
fiscal_day_tax 3 0
fiscal_sale_history 3 0
installed_plugin 2 0
inventory 1 3 0
inventory_item 5 0
invoice_field 3 35
invoice_layout 2 2 1
invoice_printer 4 0
liaison 3 0
military_data 1 2 0
on_sale_info 1 2 15
parameter_data 2 34
payment 6 7 4
payment_adapt_to_in_payment 3 3
payment_adapt_to_out_payment 3 1
payment_category 1 2 0
payment_change_history 3 0
payment_destination 3 4 1
payment_group 6 5 4
payment_method 1 3 6
payment_method_details 1 2 0
payment_renegotiation 1 6 0
person 18 2 21
person_adapt_to_bank_branch 4 0
person_adapt_to_branch 13 4 2
person_adapt_to_client 2 3 4
person_adapt_to_company 3 12
person_adapt_to_credit_provider 3 3 8
person_adapt_to_employee 4 8 5
person_adapt_to_individual 4 9
person_adapt_to_sales_person 2 3 5
person_adapt_to_supplier 3 3 1
person_adapt_to_transporter 2 3 1
person_adapt_to_user 4 4 5
product 6 3 10
product_adapt_to_storable 1 3 10
product_component 4 0
product_history 4 29
product_retention_history 4 0
product_stock_item 4 10
product_supplier_info 4 10
profile_settings 3 27
purchase_item 1 4 10
purchase_order 3 6 1
quotation 4 0
quote_group 1 2 0
receiving_order 1 8 1
receiving_order_item 5 10
renegotiation_data 5 0
sale 5 7 3
sale_item 1 4 9
sale_item_adapt_to_delivery 1 3 0
sellable 9 7 15
sellable_category 3 4 18
sellable_tax_constant 2 2 4
sellable_unit 1 2 3
service 3 5
system_table 22
till 2 3 1
till_entry 3 4
transaction_entry 168 2 876
transfer_order 1 6 1
transfer_order_item 4 10
user_profile 2 2 3
voter_data 1 2 0
work_permit_data 1 2 0

Total rows: 1,336