SchemaSpy Analysis of stoq_romaia.public Generated by
SchemaSpy
Generated by SchemaSpy on Qui Fev 02 11:05 BRST 2012
Database Type: PostgreSQL - 8.4.9 SourceForge.net

Please support this project

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

110 Tables:

Table Children Parents Rows Comments
account 5 4 9
account_transaction 5 1
address 4 15
bank_account 3 3 23
bill_option 3 3
branch_station 6 3 2
branch_synchronization 1 0
calls 4 11
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 19
city_location 2 2 12
client_category 3 2 0
client_category_price 4 0
commission 5 12
commission_source 4 7
credit_card_data 4 0
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 7
employee_role_history 4 6
event 2 1.187
fiscal_book_entry 6 27
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
parameter_data 2 49
payment 8 6 75
payment_adapt_to_in_payment 3 33
payment_adapt_to_out_payment 3 42
payment_category 1 2 0
payment_change_history 3 5
payment_comment 4 0
payment_flow_history 2 39
payment_group 5 5 33
payment_method 1 3 7
payment_renegotiation 1 6 0
person 17 2 24
person_adapt_to_branch 15 4 2
person_adapt_to_client 3 4 6
person_adapt_to_company 3 14
person_adapt_to_credit_provider 1 3 8
person_adapt_to_employee 6 8 5
person_adapt_to_individual 4 10
person_adapt_to_sales_person 2 3 5
person_adapt_to_supplier 3 3 2
person_adapt_to_transporter 3 3 1
person_adapt_to_user 10 4 5
product 9 5 10
product_adapt_to_storable 1 3 10
product_component 4 0
product_history 4 47
product_icms_template 1 3 0
product_ipi_template 1 3 0
product_quality_test 1 3 0
product_stock_item 4 20
product_supplier_info 4 10
product_tax_template 2 2 0
production_item 4 0
production_item_quality_result 5 0
production_material 4 0
production_order 4 4 0
production_produced_item 1 5 0
production_service 4 0
profile_settings 3 36
purchase_item 1 4 20
purchase_order 3 7 11
quotation 4 2
quote_group 1 2 2
receiving_order 1 8 5
receiving_order_item 5 14
renegotiation_data 5 6
sale 5 9 17
sale_item 1 7 24
sale_item_adapt_to_delivery 1 3 0
sale_item_icms 1 2 24
sale_item_ipi 1 2 24
sellable 12 6 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 53
till 2 3 9
till_entry 3 37
transaction_entry 206 2 4.556
transfer_order 1 6 1
transfer_order_item 4 10
ui_field 3 78
ui_form 1 2 6
user_profile 2 2 3
voter_data 1 2 0
work_permit_data 1 2 2

Total rows: 6.828