SchemaSpy Analysis of jdahlin.public Generated by
SchemaSpy
Generated by SchemaSpy on Tue Sep 23 20:54 GMT-03:00 2008
Database Type: PostgreSQL - 8.3.3 SourceForge.net

Please support this project

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

96 Tables and 3 Views:

Table Children Parents Rows Comments
abstract_payment_group 3 2 90
address 4 36
asellable 7 5 15
bank 1 2 0
bank_account 3 2 75
base_sellable_info 1 2 18
branch_station 5 3 3
branch_synchronization 1 0
calls 4 0
card_installment_settings 3 2 7
card_installments_provider_details 1 3
card_installments_store_details 1 3
cfop_data 5 2 4
check_data 4 69
city_location 2 2 14
commission 5 1
commission_source 4 0
credit_card_details 1 3
credit_provider_group_data 5 0
debit_card_details 3
delivery_item 4 6
device_constant 3 54
device_settings 1 3 4
employee_role 2 2 7
employee_role_history 4 12
fiscal_book_entry 6 83
fiscal_day_history 1 3 0
fiscal_day_tax 3 0
fiscal_sale_history 3 0
inheritable_model 2 34
inheritable_model_adapter 2 118
installed_plugin 2 0
inventory 1 3 0
inventory_item 5 0
invoice_field 3 0
invoice_layout 2 2 0
invoice_printer 4 0
liaison 3 3
military_data 1 2 0
on_sale_info 1 2 29
parameter_data 2 40
payment 5 7 160
payment_adapt_to_in_payment 3 110
payment_adapt_to_out_payment 3 50
payment_category 1 2 0
payment_change_history 3 0
payment_destination 3 4 1
payment_method 1 3 5
payment_method_details 1 2 14
person 16 2 37
person_adapt_to_bank_branch 4 0
person_adapt_to_branch 12 4 2
person_adapt_to_client 1 3 9
person_adapt_to_company 3 12
person_adapt_to_credit_provider 2 3 5
person_adapt_to_employee 4 8 11
person_adapt_to_individual 4 24
person_adapt_to_sales_person 2 3 8
person_adapt_to_supplier 3 3 3
person_adapt_to_transporter 2 3 4
person_adapt_to_user 3 4 9
product 7 2 10
product_adapt_to_sellable 1 10
product_adapt_to_storable 1 3 10
product_component 4 0
product_history 4 64
product_retention_history 4 6
product_stock_item 4 20
product_supplier_info 4 10
profile_settings 3 36
purchase_item 1 4 80
purchase_order 4 5 26
purchase_order_adapt_to_payment_group 1 26
purchase_order_view view
quotation 4 0
quote_group 1 2 0
receiving_order 1 8 25
receiving_order_item 5 73
renegotiation_data 5 14
sale 6 6 83
sale_adapt_to_payment_group 1 64
sale_item 1 4 103
sale_item_adapt_to_delivery 1 3 5
sale_view view
sellable_category 3 4 18
sellable_tax_constant 2 2 7
sellable_unit 1 2 4
service 1 2 5
service_adapt_to_sellable 1 5
system_table 54
till 2 3 29
till_entry 3 103
till_fiscal_operations_view view
transaction_entry 166 2 5,586
transfer_order 1 6 0
transfer_order_item 4 0
user_profile 2 2 4
voter_data 1 2 0
work_permit_data 1 2 6

Total rows: 7,684