SchemaSpy Analysis of stoq_schema.public Generated by
SchemaSpy
Generated by SchemaSpy on Fri Jun 10 16:06 BRT 2016
Database Type: PostgreSQL - 9.3.13 SourceForge.net


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

Table Children Parents Columns Comments
account 5 3 7
account_transaction 4 10
address 1 3 10
attachment 1 1 5
bank_account 3 2 7
bill_option 2 5
branch 29 3 8
branch_station 5 2 5
branch_synchronization 1 4
calls 3 7
card_operation_cost 3 10
card_payment_device 3 1 4
cfop_data 7 1 4
check_data 3 4
city_location 2 6
client 6 3 8
client_category 4 1 4
client_category_price 3 7
client_salary_history 3 7
commission 3 6
commission_source 3 6
company 2 8
contact_info 2 5
cost_center 3 1 6
cost_center_entry 4 5
credit_card_data 4 13
credit_check_history 3 9
credit_provider 2 2 8
delivery 1 4 10
device_constant 2 9
device_settings 1 2 8
employee 9 8 17
employee_role 2 1 3
employee_role_history 3 8
event 4
fiscal_book_entry 5 13
fiscal_day_history 1 2 14
fiscal_day_tax 2 6
fiscal_sale_history 2 7
grid_attribute 3 2 5
grid_group 1 1 4
grid_option 1 2 6
image 1 1 5
individual 3 16
installed_plugin 1 4
inventory 1 3 9
inventory_item 5 12
invoice 5 2 8
invoice_field 2 9
invoice_item_cofins 4 1 8
invoice_item_icms 5 1 22
invoice_item_ipi 5 1 14
invoice_item_pis 4 1 8
invoice_layout 2 1 6
invoice_printer 3 6
loan 1 6 14
loan_item 6 12
login_user 23 3 7
military_data 1 1 5
parameter_data 1 5
payment 8 6 23
payment_category 1 1 5
payment_change_history 2 9
payment_comment 3 6
payment_flow_history 1 13
payment_group 6 4 5
payment_method 1 2 10
payment_renegotiation 1 5 14
person 17 2 9
plugin_egg 1 5
product 12 8 27
product_attribute 3 4
product_cofins_template 1 2 6
product_component 3 7
product_history 3 15
product_icms_template 1 2 17
product_ipi_template 1 2 12
product_manufacturer 1 1 4
product_option_map 4 5
product_pis_template 1 2 6
product_quality_test 1 2 7
product_stock_item 4 7
product_supplier_info 3 11
product_tax_template 4 1 4
production_item 3 7
production_item_quality_result 4 8
production_material 3 10
production_order 4 3 12
production_produced_item 1 4 9
production_service 3 5
profile_settings 2 5
purchase_item 2 4 12
purchase_order 3 6 22
purchase_receiving_map 3 4
quotation 4 6
quote_group 1 2 4
receiving_order 2 6 22
receiving_order_item 1 6 9
returned_sale 1 8 17
returned_sale_item 1 10 13
sale 7 11 28
sale_comment 3 6
sale_item 4 11 20
sale_token 1 1 4
sales_person 1 2 6
sellable 14 6 19
sellable_category 3 3 7
sellable_tax_constant 2 1 5
sellable_unit 1 1 5
service 1 2 2
stock_decrease 1 9 16
stock_decrease_item 8 11
stock_transaction_history 1 5 12
storable 3 2 5
storable_batch 10 2 7
supplier 3 2 6
system_table 4
till 1 4 11
till_entry 4 9
transaction_entry 130 3
transfer_order 1 7 15
transfer_order_item 8 11
transporter 4 2 6
ui_field 2 7
ui_form 1 1 4
user_branch_access 3 4
user_profile 2 1 4
voter_data 1 1 5
work_order 3 10 26
work_order_category 1 1 4
work_order_history 3 9
work_order_item 5 9
work_order_package 1 5 10
work_order_package_item 3 4
work_permit_data 1 1 7
         
135 Tables     1,179  
0 Views     0