SchemaSpy - stoq_schema.public

Generated by
SchemaSpy

Generated by SchemaSpy on Fri Jun 10 16:06 BRT 2016
Database Type: PostgreSQL - 9.3.13
XML Representation Insertion Order Deletion Order (for database loading/purging scripts)

Comments

Table	Children	Parents	Columns
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