SchemaSpy Analysis of jdahlin.public Generated by
SchemaSpy
Generated by SchemaSpy on Sex Jun 10 16:28 BRT 2011
Database Type: PostgreSQL - 8.4.8 SourceForge.net

Please support this project

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

106 Tables:

Table Children Parents Rows Comments
account 4 4 10
account_transaction 5 7
address 4 12
bank 1 2 0
bank_account 2 2 3
base_sellable_info 1 2 15
branch_station 6 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 7 2 4
check_data 4 3
city_location 2 2 11
client_category 1 2 1
commission 5 8
commission_source 4 7
credit_card_data 4 2
credit_card_details 1 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 7
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
loan 1 5 0
loan_item 4 0
military_data 1 2 0
on_sale_info 1 2 15
parameter_data 2 45
payment 8 6 11
payment_adapt_to_in_payment 3 10
payment_adapt_to_out_payment 3 1
payment_category 1 2 0
payment_change_history 3 0
payment_comment 4 0
payment_flow_history 2 5
payment_group 5 5 7
payment_method 1 3 6
payment_renegotiation 1 6 0
person 18 2 21
person_adapt_to_bank_branch 4 0
person_adapt_to_branch 15 4 2
person_adapt_to_client 3 4 4
person_adapt_to_company 3 12
person_adapt_to_credit_provider 1 3 8
person_adapt_to_employee 6 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 3 3 1
person_adapt_to_user 8 4 5
product 7 5 10
product_adapt_to_storable 1 3 10
product_component 4 0
product_history 4 32
product_icms_template 1 3 0
product_ipi_template 1 3 0
product_stock_item 4 20
product_supplier_info 4 10
product_tax_template 2 2 0
production_item 4 0
production_material 4 0
production_order 3 4 0
production_service 4 0
profile_settings 3 33
purchase_item 1 4 10
purchase_order 3 7 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 8 6
sale_item 1 7 12
sale_item_adapt_to_delivery 1 3 0
sale_item_icms 1 2 12
sale_item_ipi 1 2 12
sellable 11 8 15
sellable_category 3 4 18
sellable_tax_constant 2 2 4
sellable_unit 1 2 3
service 1 3 5
stock_decrease 1 6 0
stock_decrease_item 4 0
system_table 31
till 2 3 2
till_entry 3 11
transaction_entry 198 2 1.152
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.746