stoq_schema.public contains 1179 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
bank_account	account_id	uuid	2147483647	√		null
branch	acronym	text	2147483647	√		null
inventory_item	actual_quantity	numeric	20,3	√		null
delivery	address_id	uuid	2147483647	√		null
employee	admission_date	timestamp	29,6	√		null
production_material	allocated	numeric	20,3	√		0
sellable_unit	allow_fraction	bool	1	√		true
profile_settings	app_dir_name	text	2147483647	√		null
work_order	approve_date	timestamp	29,6	√		null
payment	attachment_id	uuid	2147483647	√		null
calls	attendant_id	uuid	2147483647	√		null
grid_option	attribute_id	uuid	2147483647	√		null
product_attribute	attribute_id	uuid	2147483647	√		null
product_option_map	attribute_id	uuid	2147483647	√		null
credit_card_data	auth	int4	10	√		null
payment_comment	author_id	uuid	2147483647	√		null
sale_item	average_cost	numeric	20,8	√		0
payment_flow_history	balance_expected	numeric	20,2	√		null
payment_flow_history	balance_real	numeric	20,2	√		null
bank_account	bank_account	text	2147483647	√		null
bill_option	bank_account_id	uuid	2147483647	√		null
check_data	bank_account_id	uuid	2147483647	√		null
employee	bank_account_id	uuid	2147483647	√		null
bank_account	bank_branch	text	2147483647	√		null
bank_account	bank_number	int4	10	√		null
bank_account	bank_type	int8	19	√		null
sellable	barcode	text	2147483647	√		null
product_supplier_info	base_cost	numeric	20,8	√		null
purchase_item	base_cost	numeric	20,8	√		null
loan_item	base_price	numeric	20,2	√		null
sale_item	base_price	numeric	20,2	√		null
sellable	base_price	numeric	20,2	√		null
payment	base_value	numeric	20,2	√		null
inventory_item	batch_id	uuid	2147483647	√		null
loan_item	batch_id	uuid	2147483647	√		null
product_stock_item	batch_id	uuid	2147483647	√		null
receiving_order_item	batch_id	uuid	2147483647	√		null
returned_sale_item	batch_id	uuid	2147483647	√		null
sale_item	batch_id	uuid	2147483647	√		null
stock_decrease_item	batch_id	uuid	2147483647	√		null
stock_transaction_history	batch_id	uuid	2147483647	√		null
transfer_order_item	batch_id	uuid	2147483647	√		null
work_order_item	batch_id	uuid	2147483647	√		null
invoice_item_icms	bc_include_ipi	bool	1	√		true
product_icms_template	bc_include_ipi	bool	1	√		true
invoice_item_icms	bc_st_include_ipi	bool	1	√		true
product_icms_template	bc_st_include_ipi	bool	1	√		true
employee_role_history	began	timestamp	29,6	√		null
payment	bill_received	bool	1	√		false
individual	birth_date	timestamp	29,6	√		null
individual	birth_location_id	int8	19	√		null
attachment	blob	bytea	2147483647	√		null
branch_station	branch_id	uuid	2147483647	√		null
employee	branch_id	uuid	2147483647	√		null
invoice	branch_id	uuid	2147483647	√		null
work_order	branch_id	uuid	2147483647	√		null
device_settings	brand	text	2147483647	√		null
product	brand	text	2147483647	√		null
cost_center	budget	numeric	20,2	√		null
invoice_item_ipi	c_enq	text	2147483647	√		null
product_ipi_template	c_enq	text	2147483647	√		null
invoice_item_ipi	c_selo	text	2147483647	√		null
product_ipi_template	c_selo	text	2147483647	√		null
invoice_item_ipi	calculo	product_ipi_template_calculo	2147483647	√		null
branch	can_execute_foreign_work_orders	bool	1	√		false
payment	cancel_date	timestamp	29,6	√		null
production_order	cancel_date	timestamp	29,6	√		null
sale	cancel_date	timestamp	29,6	√		null
transfer_order	cancel_date	timestamp	29,6	√		null
transfer_order	cancel_responsible_id	uuid	2147483647	√		null
military_data	category	text	2147483647	√		null
client	category_id	uuid	2147483647	√		null
client_category_price	category_id	uuid	2147483647	√		null
commission_source	category_id	uuid	2147483647	√		null
payment	category_id	uuid	2147483647	√		null
sellable	category_id	uuid	2147483647	√		null
sellable_category	category_id	uuid	2147483647	√		null
work_order	category_id	uuid	2147483647	√		null
inventory_item	cfop_data_id	uuid	2147483647	√		null
fiscal_book_entry	cfop_id	uuid	2147483647	√		null
receiving_order	cfop_id	uuid	2147483647	√		null
sale	cfop_id	uuid	2147483647	√		null
sale_item	cfop_id	uuid	2147483647	√		null
stock_decrease	cfop_id	uuid	2147483647	√		null
payment_change_history	change_date	timestamp	29,6	√		null
payment_change_history	change_reason	text	2147483647	√		null
credit_check_history	check_date	timestamp	29,6	√		null
city_location	city	text	2147483647	√		null
city_location	city_code	int4	10	√		null
address	city_location_id	int8	19	√		null
company	city_registry	text	2147483647	√		null
invoice_item_ipi	cl_enq	text	2147483647	√		null
product_ipi_template	cl_enq	text	2147483647	√		null
loan	client_category_id	uuid	2147483647	√		null
sale	client_category_id	uuid	2147483647	√		null
client_salary_history	client_id	uuid	2147483647	√		null
credit_check_history	client_id	uuid	2147483647	√		null
loan	client_id	uuid	2147483647	√		null
payment_renegotiation	client_id	uuid	2147483647	√		null
sale	client_id	uuid	2147483647	√		null
work_order	client_id	uuid	2147483647	√		null
inventory	close_date	timestamp	29,6	√		null
loan	close_date	timestamp	29,6	√		null
payment_renegotiation	close_date	timestamp	29,6	√		null
production_order	close_date	timestamp	29,6	√		null
sale	close_date	timestamp	29,6	√		null
till	closing_date	timestamp	29,6	√		null
payment_method	closing_day	int4	10	√		null
invoice	cnf	text	2147483647	√		null
company	cnpj	text	2147483647	√		null
invoice_item_ipi	cnpj_prod	text	2147483647	√		null
product_ipi_template	cnpj_prod	text	2147483647	√		null
account	code	text	2147483647	√		null
account_transaction	code	text	2147483647	√		null
cfop_data	code	text	2147483647	√		null
fiscal_day_tax	code	text	2147483647	√		null
product_manufacturer	code	text	2147483647	√		null
sale_token	code	text	2147483647	√		null
sellable	code	text	2147483647	√		null
returned_sale_item	cofins_info_id	uuid	2147483647	√		null
sale_item	cofins_info_id	uuid	2147483647	√		null
stock_decrease_item	cofins_info_id	uuid	2147483647	√		null
transfer_order_item	cofins_info_id	uuid	2147483647	√		null
product	cofins_template_id	uuid	2147483647	√		null
payment_category	color	text	2147483647	√		null
work_order_category	color	text	2147483647	√		null
sales_person	comission	numeric	10,2	√		null
sales_person	comission_type	int4	10	√		null
payment_comment	comment	text	2147483647	√		null
sale_comment	comment	text	2147483647	√		null
transfer_order	comments	text	2147483647	√		null
client_category_price	commission	numeric	10,2	√		null
sellable	commission	numeric	10,2	√		null
address	complement	text	2147483647	√		null
sale_item	completion_date	timestamp	29,6	√		null
product_component	component_id	uuid	2147483647	√		null
purchase_order	confirm_date	timestamp	29,6	√		null
receiving_order	confirm_date	timestamp	29,6	√		null
returned_sale	confirm_date	timestamp	29,6	√		null
sale	confirm_date	timestamp	29,6	√		null
stock_decrease	confirm_date	timestamp	29,6	√		null
returned_sale	confirm_responsible_id	uuid	2147483647	√		null
purchase_order	consigned	bool	1	√		false
device_constant	constant_enum	int4	10	√		null
device_constant	constant_name	text	2147483647	√		null
device_constant	constant_type	int4	10	√		null
device_constant	constant_value	numeric	10,2	√		null
production_material	consumed	numeric	20,3	√		0
contact_info	contact_info	text	2147483647	√		null
invoice_field	content	text	2147483647	√		null
invoice_layout	continuous_page	bool	1	√		null
fiscal_sale_history	coo	int4	10	√		null
purchase_item	cost	numeric	20,8	√		null
receiving_order_item	cost	numeric	20,8	√		null
sellable	cost	numeric	20,8	√		null
stock_decrease_item	cost	numeric	20,8	√		0
sale	cost_center_id	uuid	2147483647	√		null
stock_decrease	cost_center_id	uuid	2147483647	√		null
inventory_item	counted_quantity	numeric	20,3	√		null
city_location	country	text	2147483647	√		null
fiscal_day_history	coupon_end	int4	10	√		null
sale	coupon_id	int4	10	√		null
fiscal_day_history	coupon_start	int4	10	√		null
individual	cpf	text	2147483647	√		null
credit_check_history	creation_date	timestamp	29,6	√		null
client	credit_limit	numeric	20,2	√		0
fiscal_day_history	cro	int4	10	√		null
branch	crt	int4	10	√		1
fiscal_day_history	crz	int4	10	√		null
invoice_item_icms	csosn	int4	10	√		null
product_icms_template	csosn	int4	10	√		null
invoice_item_cofins	cst	int4	10	√		null
invoice_item_icms	cst	int4	10	√		null
invoice_item_ipi	cst	int4	10	√		null
invoice_item_pis	cst	int4	10	√		null
product_cofins_template	cst	int4	10	√		null
product_icms_template	cst	int4	10	√		null
product_ipi_template	cst	int4	10	√		null
product_pis_template	cst	int4	10	√		null
work_order	current_branch_id	uuid	2147483647	√		null
payment_method	daily_interest	numeric	10,2	√		null
calls	date	timestamp	29,6	√		null
client_salary_history	date	timestamp	29,6	√		null
fiscal_book_entry	date	timestamp	29,6	√		null
payment_comment	date	timestamp	29,6	√		null
sale_comment	date	timestamp	29,6	√		null
stock_transaction_history	date	timestamp	29,6	√		null
till_entry	date	timestamp	29,6	√		null
client	days_late	int4	10	√		null
product_history	decreased_date	timestamp	29,6	√		null
credit_provider	default_device_id	uuid	2147483647	√		null
sellable	default_sale_cfop_id	uuid	2147483647	√		null
work_order	defect_detected	text	2147483647	√		null
work_order	defect_reported	text	2147483647	√		null
delivery	deliver_date	timestamp	29,6	√		null
sale_item	delivery_id	uuid	2147483647	√		null
employee	dependent_person_number	int4	10	√		null
product	depth	numeric	10,2	√		null
account_transaction	description	text	2147483647	√		null
calls	description	text	2147483647	√		null
card_payment_device	description	text	2147483647	√		null
cfop_data	description	text	2147483647	√		null
contact_info	description	text	2147483647	√		null
cost_center	description	text	2147483647	√		null
grid_attribute	description	text	2147483647	√		null
grid_group	description	text	2147483647	√		null
grid_option	description	text	2147483647	√		null
image	description	text	2147483647	√		null
payment	description	text	2147483647	√		null
product_quality_test	description	text	2147483647	√		null
production_order	description	text	2147483647	√		null
sellable	description	text	2147483647	√		null
sellable_category	description	text	2147483647	√		null
sellable_tax_constant	description	text	2147483647	√		null
sellable_unit	description	text	2147483647	√		null
till_entry	description	text	2147483647	√		null
ui_field	description	text	2147483647	√		null
ui_form	description	text	2147483647	√		null
work_order	description	text	2147483647	√		null
product_component	design_reference	text	2147483647	√		null
work_order_package	destination_branch_id	uuid	2147483647	√		null
transfer_order	destination_responsible_id	uuid	2147483647	√		null
card_operation_cost	device_id	uuid	2147483647	√		null
credit_card_data	device_id	uuid	2147483647	√		null
device_settings	device_name	text	2147483647	√		null
device_constant	device_settings_id	uuid	2147483647	√		null
device_constant	device_value	bytea	2147483647	√		null
transaction_entry	dirty	bool	1	√		true
payment	discount	numeric	20,2	√		null
payment_renegotiation	discount_value	numeric	20,2	√		null
purchase_order	discount_value	numeric	20,2	√		null
receiving_order	discount_value	numeric	20,2	√		null
sale	discount_value	numeric	20,2	√		null
address	district	text	2147483647	√		null
fiscal_sale_history	document	text	2147483647	√		null
fiscal_sale_history	document_counter	int4	10	√		null
fiscal_sale_history	document_type	int4	10	√		null
fiscal_book_entry	drawee_id	uuid	2147483647	√		null
payment	due_date	timestamp	29,6	√		null
employee	education_level	text	2147483647	√		null
plugin_egg	egg_content	bytea	2147483647	√		null
plugin_egg	egg_md5sum	text	2147483647	√		null
person	email	text	2147483647	√		null
fiscal_day_history	emission_date	date	13	√		null
employee_role_history	employee_id	uuid	2147483647	√		null
employee_role_history	ended	timestamp	29,6	√		null
production_produced_item	entered_stock	bool	1	√		null
credit_card_data	entrance_value	numeric	20,2	√		0
fiscal_book_entry	entry_type	int4	10	√		null
work_order	estimated_cost	numeric	20,2	√		null
work_order	estimated_finish	timestamp	29,6	√		null
sale_item	estimated_fix_date	timestamp	29,6	√		null
work_order	estimated_hours	numeric	10,2	√		null
work_order	estimated_start	timestamp	29,6	√		null
product	ex_tipi	text	2147483647	√		null
work_order	execution_branch_id	uuid	2147483647	√		null
work_order	execution_responsible_id	uuid	2147483647	√		null
purchase_order	expected_freight	numeric	20,2	√		null
purchase_order	expected_pay_date	timestamp	29,6	√		null
purchase_item	expected_receival_date	timestamp	29,6	√		null
purchase_order	expected_receival_date	timestamp	29,6	√		null
production_order	expected_start_date	timestamp	29,6	√		null
receiving_order	expense_value	numeric	20,2	√		null
loan	expire_date	timestamp	29,6	√		null
sale	expire_date	timestamp	29,6	√		null
storable_batch	expire_date	timestamp	29,6	√		null
employee	expire_vacation	timestamp	29,6	√		null
product	family	text	2147483647	√		null
company	fancy_name	text	2147483647	√		null
card_operation_cost	fare	numeric	20,2	√		null
credit_card_data	fare	numeric	20,2	√		0
individual	father_name	text	2147483647	√		null
person	fax_number	text	2147483647	√		null
card_operation_cost	fee	numeric	10,2	√		null
credit_card_data	fee_value	numeric	20,2	√		0
ui_field	field_name	text	2147483647	√		null
parameter_data	field_value	text	2147483647	√		null
till	final_cash_amount	numeric	20,2	√		null
work_order	finish_date	timestamp	29,6	√		null
fiscal_day_tax	fiscal_day_history_id	uuid	2147483647	√		null
ui_form	form_name	text	2147483647	√		null
receiving_order	freight_total	numeric	20,2	√		null
system_table	generation	int4	10	√		null
product	genero	text	2147483647	√		null
grid_attribute	group_id	uuid	2147483647	√		null
payment	group_id	uuid	2147483647	√		null
payment_renegotiation	group_id	uuid	2147483647	√		null
purchase_order	group_id	uuid	2147483647	√		null
quotation	group_id	uuid	2147483647	√		null
sale	group_id	uuid	2147483647	√		null
stock_decrease	group_id	uuid	2147483647	√		null
profile_settings	has_permission	bool	1	√		null
product	height	numeric	10,2	√		null
payment_flow_history	history_date	timestamp	29,6	√		null
product_supplier_info	icms	numeric	10,2	√		null
loan_item	icms_info_id	uuid	2147483647	√		null
returned_sale_item	icms_info_id	uuid	2147483647	√		null
sale_item	icms_info_id	uuid	2147483647	√		null
stock_decrease_item	icms_info_id	uuid	2147483647	√		null
transfer_order_item	icms_info_id	uuid	2147483647	√		null
product	icms_template_id	uuid	2147483647	√		null
receiving_order	icms_total	numeric	20,2	√		null
fiscal_book_entry	icms_value	numeric	20,2	√		null
credit_check_history	identifier	text	2147483647	√		null
image	image	bytea	2147483647	√		null
sellable	image_id	uuid	2147483647	√		null
till	initial_cash_amount	numeric	20,2	√		null
card_operation_cost	installment_end	int4	10	√		null
card_operation_cost	installment_start	int4	10	√		null
credit_card_data	installments	int4	10	√		1
payment	interest	numeric	20,2	√		null
product	internal_use	bool	1	√		false
loan	invoice_id	uuid	2147483647	√		null
returned_sale	invoice_id	uuid	2147483647	√		null
sale	invoice_id	uuid	2147483647	√		null
stock_decrease	invoice_id	uuid	2147483647	√		null
transfer_order	invoice_id	uuid	2147483647	√		null
fiscal_book_entry	invoice_number	int4	10	√		null
inventory	invoice_number	int4	10	√		null
invoice	invoice_number	int4	10	√		null
receiving_order	invoice_number	int4	10	√		null
returned_sale	invoice_number	int4	10	√		null
sale	invoice_number	int4	10	√		null
stock_decrease	invoice_number	int4	10	√		null
transfer_order	invoice_number	int4	10	√		null
receiving_order	invoice_total	numeric	20,2	√		null
loan_item	ipi_info_id	uuid	2147483647	√		null
returned_sale_item	ipi_info_id	uuid	2147483647	√		null
sale_item	ipi_info_id	uuid	2147483647	√		null
stock_decrease_item	ipi_info_id	uuid	2147483647	√		null
transfer_order_item	ipi_info_id	uuid	2147483647	√		null
product	ipi_template_id	uuid	2147483647	√		null
receiving_order	ipi_total	numeric	20,2	√		null
fiscal_book_entry	ipi_value	numeric	20,2	√		null
branch	is_active	bool	1	√		null
branch_station	is_active	bool	1	√		null
company	is_active	bool	1	√		null
credit_provider	is_active	bool	1	√		null
device_settings	is_active	bool	1	√		null
employee	is_active	bool	1	√		null
employee_role_history	is_active	bool	1	√		null
grid_attribute	is_active	bool	1	√		true
grid_group	is_active	bool	1	√		true
grid_option	is_active	bool	1	√		true
individual	is_active	bool	1	√		null
login_user	is_active	bool	1	√		null
payment_method	is_active	bool	1	√		null
sales_person	is_active	bool	1	√		null
supplier	is_active	bool	1	√		null
transporter	is_active	bool	1	√		null
storable	is_batch	bool	1	√		false
product	is_composed	bool	1	√		false
parameter_data	is_editable	bool	1	√		null
product	is_grid	bool	1	√		false
address	is_main_address	bool	1	√		null
product_supplier_info	is_main_supplier	bool	1	√		null
product	is_package	bool	1	√		false
fiscal_book_entry	is_reversal	bool	1	√		null
device_constant	is_valid_model	bool	1	√		null
fiscal_book_entry	iss_value	numeric	20,2	√		null
invoice	key	text	2147483647	√		null
payment_change_history	last_due_date	timestamp	29,6	√		null
invoice_field	layout_id	uuid	2147483647	√		null
invoice_printer	layout_id	uuid	2147483647	√		null
product_supplier_info	lead_time	int4	10	√		1
loan_item	loan_id	uuid	2147483647	√		null
product	location	text	2147483647	√		null
production_item	lost	numeric	20,3	√		0
production_material	lost	numeric	20,3	√		0
product	manage_stock	bool	1	√		true
branch	manager_id	uuid	2147483647	√		null
ui_field	mandatory	bool	1	√		null
product	manufacturer_id	uuid	2147483647	√		null
client_category	max_discount	numeric	10,2	√		0
client_category_price	max_discount	numeric	10,2	√		null
sellable	max_discount	numeric	10,2	√		null
user_profile	max_discount	numeric	10,2	√		0
credit_provider	max_installments	int4	10	√		12
payment_method	max_installments	int4	10	√		null
storable	maximum_quantity	numeric	20,3	√		0
person	merged_with_id	uuid	2147483647	√		null
calls	message	text	2147483647	√		null
payment	method_id	uuid	2147483647	√		null
payment_method	method_name	text	2147483647	√		null
employee	military_data_id	uuid	2147483647	√		null
attachment	mimetype	text	2147483647	√		null
product_supplier_info	minimum_purchase	numeric	20,3	√		1
storable	minimum_quantity	numeric	20,3	√		0
person	mobile_number	text	2147483647	√		null
invoice_item_icms	mod_bc	int4	10	√		null
product_icms_template	mod_bc	int4	10	√		null
invoice_item_icms	mod_bc_st	int4	10	√		null
product_icms_template	mod_bc_st	int4	10	√		null
device_settings	model	text	2147483647	√		null
product	model	text	2147483647	√		null
card_payment_device	monthly_cost	numeric	20,2	√		null
individual	mother_name	text	2147483647	√		null
branch_station	name	text	2147483647	√		null
client_category	name	text	2147483647	√		null
payment_category	name	text	2147483647	√		null
person	name	text	2147483647	√		null
product_manufacturer	name	text	2147483647	√		null
product_tax_template	name	text	2147483647	√		null
user_profile	name	text	2147483647	√		null
product	ncm	text	2147483647	√		null
production_material	needed	numeric	20,3	√		null
payment_change_history	new_due_date	timestamp	29,6	√		null
client_salary_history	new_salary	numeric	20,2	√		0
returned_sale	new_sale_id	uuid	2147483647	√		null
work_order_history	new_value	text	2147483647	√		null
credit_check_history	notes	text	2147483647	√		null
loan	notes	text	2147483647	√		null
payment_renegotiation	notes	text	2147483647	√		null
person	notes	text	2147483647	√		null
product_quality_test	notes	text	2147483647	√		null
product_supplier_info	notes	text	2147483647	√		null
purchase_order	notes	text	2147483647	√		null
receiving_order	notes	text	2147483647	√		null
sale_item	notes	text	2147483647	√		null
sellable	notes	text	2147483647	√		null
stock_decrease	notes	text	2147483647	√		null
storable_batch	notes	text	2147483647	√		null
work_order_history	notes	text	2147483647	√		null
credit_card_data	nsu	int4	10	√		null
military_data	number	text	2147483647	√		null
voter_data	number	text	2147483647	√		null
work_permit_data	number	text	2147483647	√		null
stock_transaction_history	object_id	uuid	2147483647	√		null
till	observations	text	2147483647	√		null
individual	occupation	text	2147483647	√		null
client_salary_history	old_salary	numeric	20,2	√		0
work_order_history	old_value	text	2147483647	√		null
sellable	on_sale_end_date	timestamp	29,6	√		null
sellable	on_sale_price	numeric	20,2	√		null
sellable	on_sale_start_date	timestamp	29,6	√		null
credit_provider	open_contract_date	timestamp	29,6	√		null
transporter	open_contract_date	timestamp	29,6	√		null
delivery	open_date	timestamp	29,6	√		null
loan	open_date	timestamp	29,6	√		null
payment	open_date	timestamp	29,6	√		null
payment_renegotiation	open_date	timestamp	29,6	√		null
production_order	open_date	timestamp	29,6	√		null
sale	open_date	timestamp	29,6	√		null
work_order	open_date	timestamp	29,6	√		null
till	opening_date	timestamp	29,6	√		null
invoice	operation_nature	text	2147483647	√		null
sale	operation_nature	text	2147483647	√		null
bill_option	option	text	2147483647	√		null
product_option_map	option_id	uuid	2147483647	√		null
grid_option	option_order	int4	10	√		null
production_item	order_id	uuid	2147483647	√		null
production_material	order_id	uuid	2147483647	√		null
production_produced_item	order_id	uuid	2147483647	√		null
production_service	order_id	uuid	2147483647	√		null
purchase_item	order_id	uuid	2147483647	√		null
work_order_item	order_id	uuid	2147483647	√		null
invoice_item_icms	orig	int4	10	√		null
product_icms_template	orig	int4	10	√		null
invoice_item_cofins	p_cofins	numeric	10,2	√		null
product_cofins_template	p_cofins	numeric	10,2	√		null
invoice_item_icms	p_cred_sn	numeric	10,2	√		null
product_icms_template	p_cred_sn	numeric	10,2	√		null
product_icms_template	p_cred_sn_valid_until	timestamp	29,6	√		null
invoice_item_icms	p_icms	numeric	10,2	√		null
product_icms_template	p_icms	numeric	10,2	√		null
invoice_item_icms	p_icms_st	numeric	10,2	√		null
product_icms_template	p_icms_st	numeric	10,2	√		null
invoice_item_ipi	p_ipi	numeric	10,2	√		null
product_ipi_template	p_ipi	numeric	10,2	√		null
invoice_item_icms	p_mva_st	numeric	10,2	√		null
product_icms_template	p_mva_st	numeric	10,2	√		null
invoice_item_pis	p_pis	numeric	10,2	√		null
product_pis_template	p_pis	numeric	10,2	√		null
invoice_item_icms	p_red_bc	numeric	10,2	√		null
product_icms_template	p_red_bc	numeric	10,2	√		null
invoice_item_icms	p_red_bc_st	numeric	10,2	√		null
product_icms_template	p_red_bc_st	numeric	10,2	√		null
payment_flow_history	paid	numeric	20,2	√		null
sale	paid	bool	1	√		false
payment	paid_date	timestamp	29,6	√		null
payment_flow_history	paid_payments	int4	10	√		null
payment	paid_value	numeric	20,2	√		null
account	parent_id	uuid	2147483647	√		null
product	parent_id	uuid	2147483647	√		null
purchase_item	parent_item_id	uuid	2147483647	√		null
receiving_order_item	parent_item_id	uuid	2147483647	√		null
returned_sale_item	parent_item_id	uuid	2147483647	√		null
sale_item	parent_item_id	uuid	2147483647	√		null
product	part_number	text	2147483647	√		null
system_table	patchlevel	int4	10	√		null
payment_group	payer_id	uuid	2147483647	√		null
payment_method	payment_day	int4	10	√		null
card_operation_cost	payment_days	int4	10	√		null
fiscal_book_entry	payment_group_id	uuid	2147483647	√		null
account_transaction	payment_id	uuid	2147483647	√		null
check_data	payment_id	uuid	2147483647	√		null
cost_center_entry	payment_id	uuid	2147483647	√		null
credit_card_data	payment_id	uuid	2147483647	√		null
payment_change_history	payment_id	uuid	2147483647	√		null
payment_comment	payment_id	uuid	2147483647	√		null
till_entry	payment_id	uuid	2147483647	√		null
payment	payment_number	text	2147483647	√		null
payment	penalty	numeric	20,2	√		null
payment_method	penalty	numeric	10,2	√		null
fiscal_day_history	period_total	numeric	20,2	√		null
address	person_id	uuid	2147483647	√		null
branch	person_id	uuid	2147483647	√		null
calls	person_id	uuid	2147483647	√		null
client	person_id	uuid	2147483647	√		null
company	person_id	uuid	2147483647	√		null
contact_info	person_id	uuid	2147483647	√		null
employee	person_id	uuid	2147483647	√		null
individual	person_id	uuid	2147483647	√		null
login_user	person_id	uuid	2147483647	√		null
sales_person	person_id	uuid	2147483647	√		null
stock_decrease	person_id	uuid	2147483647	√		null
supplier	person_id	uuid	2147483647	√		null
transporter	person_id	uuid	2147483647	√		null
person	phone_number	text	2147483647	√		null
work_permit_data	pis_bank	text	2147483647	√		null
returned_sale_item	pis_info_id	uuid	2147483647	√		null
sale_item	pis_info_id	uuid	2147483647	√		null
stock_decrease_item	pis_info_id	uuid	2147483647	√		null
transfer_order_item	pis_info_id	uuid	2147483647	√		null
work_permit_data	pis_number	text	2147483647	√		null
work_permit_data	pis_registry_date	timestamp	29,6	√		null
product	pis_template_id	uuid	2147483647	√		null
installed_plugin	plugin_version	int4	10	√		null
address	postal_code	text	2147483647	√		null
client_category_price	price	numeric	10,2	√		null
loan_item	price	numeric	20,2	√		null
product_component	price	numeric	20,2	√		null
returned_sale_item	price	numeric	20,2	√		null
sale_item	price	numeric	20,2	√		null
work_order_item	price	numeric	20,2	√		null
production_item	produced	numeric	20,3	√		0
production_produced_item	produced_by_id	uuid	2147483647	√		null
production_produced_item	produced_date	timestamp	29,6	√		null
production_item_quality_result	produced_item_id	uuid	2147483647	√		null
inventory_item	product_cost	numeric	20,8	√		null
supplier	product_desc	text	2147483647	√		null
product_attribute	product_id	uuid	2147483647	√		null
product_component	product_id	uuid	2147483647	√		null
product_option_map	product_id	uuid	2147483647	√		null
product_quality_test	product_id	uuid	2147483647	√		null
production_item	product_id	uuid	2147483647	√		null
production_material	product_id	uuid	2147483647	√		null
production_produced_item	product_id	uuid	2147483647	√		null
product_cofins_template	product_tax_template_id	uuid	2147483647	√		null
product_icms_template	product_tax_template_id	uuid	2147483647	√		null
product_ipi_template	product_tax_template_id	uuid	2147483647	√		null
product_pis_template	product_tax_template_id	uuid	2147483647	√		null
product_history	production_date	timestamp	29,6	√		null
product	production_time	int4	10	√		0
login_user	profile_id	uuid	2147483647	√		null
card_operation_cost	provider_id	uuid	2147483647	√		null
credit_card_data	provider_id	uuid	2147483647	√		null
credit_provider	provider_id	text	2147483647	√		null
purchase_receiving_map	purchase_id	uuid	2147483647	√		null
quotation	purchase_id	uuid	2147483647	√		null
receiving_order_item	purchase_item_id	uuid	2147483647	√		null
login_user	pw_hash	text	2147483647	√		null
invoice_item_cofins	q_bc_prod	numeric	10,4	√		null
invoice_item_pis	q_bc_prod	numeric	10,4	√		null
invoice_item_ipi	q_selo	int4	10	√		null
product_ipi_template	q_selo	int4	10	√		null
invoice_item_ipi	q_unid	numeric	16,4	√		null
product_ipi_template	q_unid	numeric	16,4	√		null
production_item_quality_result	quality_test_id	uuid	2147483647	√		null
loan_item	quantity	numeric	20,3	√		null
product_component	quantity	numeric	20,3	√		null
product_stock_item	quantity	numeric	20,3	√		null
production_item	quantity	numeric	20,3	√		null
production_service	quantity	numeric	20,3	√		null
purchase_item	quantity	numeric	20,3	√		null
receiving_order_item	quantity	numeric	20,3	√		null
returned_sale_item	quantity	numeric	20,3	√		null
sale_item	quantity	numeric	20,3	√		null
stock_decrease_item	quantity	numeric	20,3	√		null
stock_transaction_history	quantity	numeric	20,3	√		null
work_order	quantity	int4	10	√		1
work_order_item	quantity	numeric	20,3	√		null
product_history	quantity_consumed	numeric	20,3	√		null
product_history	quantity_decreased	numeric	20,3	√		null
sale_item	quantity_decreased	numeric	20,3	√		0
work_order_item	quantity_decreased	numeric	20,3	√		null
product_history	quantity_lost	numeric	20,3	√		null
product_history	quantity_produced	numeric	20,3	√		null
product_history	quantity_received	numeric	20,3	√		null
purchase_item	quantity_received	numeric	20,3	√		null
purchase_item	quantity_returned	numeric	20,3	√		0
product_history	quantity_sold	numeric	20,3	√		null
purchase_item	quantity_sold	numeric	20,3	√		0
product_history	quantity_transfered	numeric	20,3	√		null
purchase_order	quote_deadline	timestamp	29,6	√		null
work_order	quote_responsible_id	uuid	2147483647	√		null
inventory_item	reason	text	2147483647	√		null
returned_sale	reason	text	2147483647	√		null
stock_decrease	reason	text	2147483647	√		null
purchase_order	receival_date	timestamp	29,6	√		null
receiving_order	receival_date	timestamp	29,6	√		null
transfer_order	receival_date	timestamp	29,6	√		null
delivery	receive_date	timestamp	29,6	√		null
work_order_package	receive_date	timestamp	29,6	√		null
work_order_package	receive_responsible_id	uuid	2147483647	√		null
payment_flow_history	received	numeric	20,2	√		null
product_history	received_date	timestamp	29,6	√		null
payment_flow_history	received_payments	int4	10	√		null
purchase_receiving_map	receiving_id	uuid	2147483647	√		null
receiving_order_item	receiving_order_id	uuid	2147483647	√		null
payment_group	recipient_id	uuid	2147483647	√		null
inventory_item	recorded_quantity	numeric	20,3	√		null
fiscal_day_history	reduction_date	timestamp	29,6	√		null
employee	registry_number	text	2147483647	√		null
loan	removed_by	text	2147483647	√		null
stock_decrease	removed_by_id	uuid	2147483647	√		null
payment_group	renegotiation_id	uuid	2147483647	√		null
till	responsible_close_id	uuid	2147483647	√		null
loan	responsible_id	uuid	2147483647	√		null
payment_renegotiation	responsible_id	uuid	2147483647	√		null
production_order	responsible_id	uuid	2147483647	√		null
purchase_order	responsible_id	uuid	2147483647	√		null
receiving_order	responsible_id	uuid	2147483647	√		null
returned_sale	responsible_id	uuid	2147483647	√		null
stock_decrease	responsible_id	uuid	2147483647	√		null
till	responsible_open_id	uuid	2147483647	√		null
production_item_quality_result	result_value	text	2147483647	√		null
returned_sale	return_date	timestamp	29,6	√		null
sale	return_date	timestamp	29,6	√		null
loan_item	return_quantity	numeric	20,3	√		null
returned_sale_item	returned_sale_id	uuid	2147483647	√		null
individual	rg_expedition_date	timestamp	29,6	√		null
individual	rg_expedition_local	text	2147483647	√		null
individual	rg_number	text	2147483647	√		null
employee	role_id	uuid	2147483647	√		null
employee_role_history	role_id	uuid	2147483647	√		null
client	salary	numeric	20,2	√		0
employee	salary	numeric	20,2	√		null
employee_role_history	salary	numeric	20,2	√		null
fiscal_sale_history	sale_id	uuid	2147483647	√		null
returned_sale	sale_id	uuid	2147483647	√		null
sale_item	sale_id	uuid	2147483647	√		null
work_order	sale_id	uuid	2147483647	√		null
returned_sale_item	sale_item_id	uuid	2147483647	√		null
work_order_item	sale_item_id	uuid	2147483647	√		null
loan_item	sale_quantity	numeric	20,3	√		null
sale	sale_token_id	uuid	2147483647	√		null
sellable_category	salesperson_commission	numeric	10,2	√		null
sale	salesperson_id	uuid	2147483647	√		null
purchase_order	salesperson_name	text	2147483647	√		null
voter_data	section	text	2147483647	√		null
receiving_order	secure_value	numeric	20,2	√		null
client_category_price	sellable_id	uuid	2147483647	√		null
commission_source	sellable_id	uuid	2147483647	√		null
loan_item	sellable_id	uuid	2147483647	√		null
product_history	sellable_id	uuid	2147483647	√		null
purchase_item	sellable_id	uuid	2147483647	√		null
receiving_order_item	sellable_id	uuid	2147483647	√		null
returned_sale_item	sellable_id	uuid	2147483647	√		null
sale_item	sellable_id	uuid	2147483647	√		null
stock_decrease_item	sellable_id	uuid	2147483647	√		null
work_order	sellable_id	uuid	2147483647	√		null
work_order_item	sellable_id	uuid	2147483647	√		null
work_order_package	send_date	timestamp	29,6	√		null
work_order_package	send_responsible_id	uuid	2147483647	√		null
fiscal_day_history	serial	text	2147483647	√		null
fiscal_day_history	serial_id	int4	10	√		null
production_produced_item	serial_number	int4	10	√		null
military_data	series_number	text	2147483647	√		null
work_permit_data	series_number	text	2147483647	√		null
production_service	service_id	uuid	2147483647	√		null
sale	service_invoice_number	int4	10	√		null
delivery	service_item_id	uuid	2147483647	√		null
credit_provider	short_name	text	2147483647	√		null
product_history	sold_date	timestamp	29,6	√		null
individual	spouse_name	text	2147483647	√		null
production_order	start_date	timestamp	29,6	√		null
city_location	state	text	2147483647	√		null
city_location	state_code	int4	10	√		null
company	state_registry	text	2147483647	√		null
account	station_id	uuid	2147483647	√		null
device_settings	station_id	uuid	2147483647	√		null
fiscal_day_history	station_id	uuid	2147483647	√		null
invoice_printer	station_id	uuid	2147483647	√		null
till	station_id	uuid	2147483647	√		null
payment_renegotiation	status	int4	10	√		null
returned_sale	status	returned_sale_status	2147483647	√		null
sale_token	status	sale_token_status	2147483647	√		'available'::sale_token_status
product_stock_item	stock_cost	numeric	20,8	√		null
stock_transaction_history	stock_cost	numeric	20,8	√		null
stock_decrease_item	stock_decrease_id	uuid	2147483647	√		null
cost_center_entry	stock_transaction_id	uuid	2147483647	√		null
product_stock_item	storable_id	uuid	2147483647	√		null
address	street	text	2147483647	√		null
address	streetnumber	int4	10	√		null
product_quality_test	success_value	text	2147483647	√		null
sellable_category	suggested_markup	numeric	10,2	√		null
product_supplier_info	supplier_code	text	2147483647	√		null
purchase_order	supplier_id	uuid	2147483647	√		null
receiving_order	supplier_id	uuid	2147483647	√		null
work_order	supplier_order	text	2147483647	√		null
payment_renegotiation	surcharge_value	numeric	20,2	√		null
purchase_order	surcharge_value	numeric	20,2	√		null
receiving_order	surcharge_value	numeric	20,2	√		null
sale	surcharge_value	numeric	20,2	√		null
sellable	tax_constant_id	uuid	2147483647	√		null
sellable_category	tax_constant_id	uuid	2147483647	√		null
fiscal_day_history	tax_total	numeric	10,2	√		null
product_tax_template	tax_type	product_tax_template_tax_type	2147483647	√		null
sellable_tax_constant	tax_type	int4	10	√		null
sellable_tax_constant	tax_value	numeric	10,2	√		null
account	te_id	int8	19	√		new_te()
account_transaction	te_id	int8	19	√		new_te()
address	te_id	int8	19	√		new_te()
attachment	te_id	int8	19	√		new_te()
bank_account	te_id	int8	19	√		new_te()
bill_option	te_id	int8	19	√		new_te()
branch	te_id	int8	19	√		new_te()
branch_station	te_id	int8	19	√		new_te()
calls	te_id	int8	19	√		new_te()
card_operation_cost	te_id	int8	19	√		new_te()
card_payment_device	te_id	int8	19	√		new_te()
cfop_data	te_id	int8	19	√		new_te()
check_data	te_id	int8	19	√		new_te()
client	te_id	int8	19	√		new_te()
client_category	te_id	int8	19	√		new_te()
client_category_price	te_id	int8	19	√		new_te()
client_salary_history	te_id	int8	19	√		new_te()
commission	te_id	int8	19	√		new_te()
commission_source	te_id	int8	19	√		new_te()
company	te_id	int8	19	√		new_te()
contact_info	te_id	int8	19	√		new_te()
cost_center	te_id	int8	19	√		new_te()
cost_center_entry	te_id	int8	19	√		new_te()
credit_card_data	te_id	int8	19	√		new_te()
credit_check_history	te_id	int8	19	√		new_te()
credit_provider	te_id	int8	19	√		new_te()
delivery	te_id	int8	19	√		new_te()
device_constant	te_id	int8	19	√		new_te()
device_settings	te_id	int8	19	√		new_te()
employee	te_id	int8	19	√		new_te()
employee_role	te_id	int8	19	√		new_te()
employee_role_history	te_id	int8	19	√		new_te()
fiscal_book_entry	te_id	int8	19	√		new_te()
fiscal_day_history	te_id	int8	19	√		new_te()
fiscal_day_tax	te_id	int8	19	√		new_te()
fiscal_sale_history	te_id	int8	19	√		new_te()
grid_attribute	te_id	int8	19	√		new_te()
grid_group	te_id	int8	19	√		new_te()
grid_option	te_id	int8	19	√		new_te()
image	te_id	int8	19	√		new_te()
individual	te_id	int8	19	√		new_te()
installed_plugin	te_id	int8	19	√		new_te()
inventory	te_id	int8	19	√		new_te()
inventory_item	te_id	int8	19	√		new_te()
invoice	te_id	int8	19	√		new_te()
invoice_field	te_id	int8	19	√		new_te()
invoice_item_cofins	te_id	int8	19	√		new_te()
invoice_item_icms	te_id	int8	19	√		new_te()
invoice_item_ipi	te_id	int8	19	√		new_te()
invoice_item_pis	te_id	int8	19	√		new_te()
invoice_layout	te_id	int8	19	√		new_te()
invoice_printer	te_id	int8	19	√		new_te()
loan	te_id	int8	19	√		new_te()
loan_item	te_id	int8	19	√		new_te()
login_user	te_id	int8	19	√		new_te()
military_data	te_id	int8	19	√		new_te()
parameter_data	te_id	int8	19	√		new_te()
payment	te_id	int8	19	√		new_te()
payment_category	te_id	int8	19	√		new_te()
payment_change_history	te_id	int8	19	√		new_te()
payment_comment	te_id	int8	19	√		new_te()
payment_flow_history	te_id	int8	19	√		new_te()
payment_group	te_id	int8	19	√		new_te()
payment_method	te_id	int8	19	√		new_te()
payment_renegotiation	te_id	int8	19	√		new_te()
person	te_id	int8	19	√		new_te()
plugin_egg	te_id	int8	19	√		new_te()
product	te_id	int8	19	√		new_te()
product_attribute	te_id	int8	19	√		new_te()
product_cofins_template	te_id	int8	19	√		new_te()
product_component	te_id	int8	19	√		new_te()
product_history	te_id	int8	19	√		new_te()
product_icms_template	te_id	int8	19	√		new_te()
product_ipi_template	te_id	int8	19	√		new_te()
product_manufacturer	te_id	int8	19	√		new_te()
product_option_map	te_id	int8	19	√		new_te()
product_pis_template	te_id	int8	19	√		new_te()
product_quality_test	te_id	int8	19	√		new_te()
product_stock_item	te_id	int8	19	√		new_te()
product_supplier_info	te_id	int8	19	√		new_te()
product_tax_template	te_id	int8	19	√		new_te()
production_item	te_id	int8	19	√		new_te()
production_item_quality_result	te_id	int8	19	√		new_te()
production_material	te_id	int8	19	√		new_te()
production_order	te_id	int8	19	√		new_te()
production_produced_item	te_id	int8	19	√		new_te()
production_service	te_id	int8	19	√		new_te()
profile_settings	te_id	int8	19	√		new_te()
purchase_item	te_id	int8	19	√		new_te()
purchase_order	te_id	int8	19	√		new_te()
purchase_receiving_map	te_id	int8	19	√		new_te()
quotation	te_id	int8	19	√		new_te()
quote_group	te_id	int8	19	√		new_te()
receiving_order	te_id	int8	19	√		new_te()
receiving_order_item	te_id	int8	19	√		new_te()
returned_sale	te_id	int8	19	√		new_te()
returned_sale_item	te_id	int8	19	√		new_te()
sale	te_id	int8	19	√		new_te()
sale_comment	te_id	int8	19	√		new_te()
sale_item	te_id	int8	19	√		new_te()
sale_token	te_id	int8	19	√		new_te()
sales_person	te_id	int8	19	√		new_te()
sellable	te_id	int8	19	√		new_te()
sellable_category	te_id	int8	19	√		new_te()
sellable_tax_constant	te_id	int8	19	√		new_te()
sellable_unit	te_id	int8	19	√		new_te()
service	te_id	int8	19	√		new_te()
stock_decrease	te_id	int8	19	√		new_te()
stock_decrease_item	te_id	int8	19	√		new_te()
stock_transaction_history	te_id	int8	19	√		new_te()
storable	te_id	int8	19	√		new_te()
storable_batch	te_id	int8	19	√		new_te()
supplier	te_id	int8	19	√		new_te()
till	te_id	int8	19	√		new_te()
till_entry	te_id	int8	19	√		new_te()
transfer_order	te_id	int8	19	√		new_te()
transfer_order_item	te_id	int8	19	√		new_te()
transporter	te_id	int8	19	√		new_te()
ui_field	te_id	int8	19	√		new_te()
ui_form	te_id	int8	19	√		new_te()
user_branch_access	te_id	int8	19	√		new_te()
user_profile	te_id	int8	19	√		new_te()
voter_data	te_id	int8	19	√		new_te()
work_order	te_id	int8	19	√		new_te()
work_order_category	te_id	int8	19	√		new_te()
work_order_history	te_id	int8	19	√		new_te()
work_order_item	te_id	int8	19	√		new_te()
work_order_package	te_id	int8	19	√		new_te()
work_order_package_item	te_id	int8	19	√		new_te()
work_permit_data	te_id	int8	19	√		new_te()
production_item_quality_result	test_passed	bool	1	√		null
production_produced_item	test_passed	bool	1	√		null
production_item_quality_result	tested_by_id	uuid	2147483647	√		null
production_item_quality_result	tested_date	timestamp	29,6	√		null
image	thumbnail	bytea	2147483647	√		null
production_material	to_make	numeric	20,3	√		null
payment_flow_history	to_pay	numeric	20,2	√		null
payment_flow_history	to_pay_payments	int4	10	√		null
production_material	to_purchase	numeric	20,3	√		null
payment_flow_history	to_receive	numeric	20,2	√		null
payment_flow_history	to_receive_payments	int4	10	√		null
fiscal_day_history	total	numeric	20,2	√		null
payment_renegotiation	total	numeric	20,2	√		null
sale	total_amount	numeric	20,2	√		null
delivery	tracking_code	text	2147483647	√		null
transfer_order_item	transfer_order_id	uuid	2147483647	√		null
delivery	transporter_id	uuid	2147483647	√		null
purchase_order	transporter_id	uuid	2147483647	√		null
receiving_order	transporter_id	uuid	2147483647	√		null
sale	transporter_id	uuid	2147483647	√		null
device_settings	type	int4	10	√		null
fiscal_day_tax	type	text	2147483647	√		null
ui_field	ui_form_id	uuid	2147483647	√		null
returned_sale	undo_date	timestamp	29,6	√		null
returned_sale	undo_reason	text	2147483647	√		null
returned_sale	undo_responsible_id	uuid	2147483647	√		null
stock_transaction_history	unit_cost	numeric	20,8	√		null
sellable	unit_id	uuid	2147483647	√		null
sellable_unit	unit_index	int4	10	√		null
system_table	updated	timestamp	29,6	√		null
client_salary_history	user_id	uuid	2147483647	√		null
credit_check_history	user_id	uuid	2147483647	√		null
profile_settings	user_profile_id	uuid	2147483647	√		null
invoice_item_cofins	v_bc	numeric	10,2	√		null
invoice_item_icms	v_bc	numeric	20,2	√		null
invoice_item_ipi	v_bc	numeric	20,2	√		null
invoice_item_pis	v_bc	numeric	10,2	√		null
invoice_item_icms	v_bc_st	numeric	20,2	√		null
invoice_item_icms	v_bc_st_ret	numeric	20,2	√		null
invoice_item_cofins	v_cofins	numeric	10,2	√		null
invoice_item_icms	v_cred_icms_sn	numeric	20,2	√		null
invoice_item_icms	v_icms	numeric	20,2	√		null
invoice_item_icms	v_icms_st	numeric	20,2	√		null
invoice_item_icms	v_icms_st_ret	numeric	20,2	√		null
invoice_item_ipi	v_ipi	numeric	20,2	√		null
invoice_item_pis	v_pis	numeric	10,2	√		null
invoice_item_ipi	v_unid	numeric	20,4	√		null
account_transaction	value	numeric	20,2	√		null
bill_option	value	text	2147483647	√		null
fiscal_day_tax	value	numeric	20,2	√		null
payment	value	numeric	20,2	√		null
till_entry	value	numeric	20,2	√		null
ui_field	visible	bool	1	√		null
employee	voter_data_id	uuid	2147483647	√		null
product	weight	numeric	10,2	√		null
product	width	numeric	10,2	√		null
employee	workpermit_data_id	uuid	2147483647	√		null
voter_data	zone	text	2147483647	√		null
account_transaction	account_id	uuid	2147483647
account	account_type	account_type	2147483647
sale_comment	author_id	uuid	2147483647
storable_batch	batch_number	text	2147483647
branch_synchronization	branch_id	uuid	2147483647
fiscal_book_entry	branch_id	uuid	2147483647
inventory	branch_id	uuid	2147483647
loan	branch_id	uuid	2147483647
payment	branch_id	uuid	2147483647
payment_renegotiation	branch_id	uuid	2147483647
product_history	branch_id	uuid	2147483647
product_stock_item	branch_id	uuid	2147483647
production_order	branch_id	uuid	2147483647
purchase_order	branch_id	uuid	2147483647
quotation	branch_id	uuid	2147483647
quote_group	branch_id	uuid	2147483647
receiving_order	branch_id	uuid	2147483647
returned_sale	branch_id	uuid	2147483647
sale	branch_id	uuid	2147483647
stock_decrease	branch_id	uuid	2147483647
stock_transaction_history	branch_id	uuid	2147483647
till_entry	branch_id	uuid	2147483647
user_branch_access	branch_id	uuid	2147483647
invoice_item_cofins	calculo	product_cofins_template_calculo	2147483647			'percentage'::product_cofins_template_calculo
invoice_item_pis	calculo	product_pis_template_calculo	2147483647			'percentage'::product_pis_template_calculo
product_cofins_template	calculo	product_cofins_template_calculo	2147483647			'percentage'::product_cofins_template_calculo
product_ipi_template	calculo	product_ipi_template_calculo	2147483647
product_pis_template	calculo	product_pis_template_calculo	2147483647			'percentage'::product_pis_template_calculo
card_operation_cost	card_type	credit_card_type	2147483647
credit_card_data	card_type	credit_card_type	2147483647
payment_category	category_type	payment_category_type	2147483647			'payable'::payment_category_type
commission	commission_type	int4	10
product	consignment	bool	1			false
cost_center_entry	cost_center_id	uuid	2147483647
storable_batch	create_date	timestamp	29,6
account_transaction	date	timestamp	29,6
event	date	timestamp	29,6
work_order_history	date	timestamp	29,6
account	description	text	2147483647
event	description	varchar	2147483647
invoice_layout	description	varchar	2147483647
invoice_printer	description	varchar	2147483647
payment_method	destination_account_id	uuid	2147483647
transfer_order	destination_branch_id	uuid	2147483647
invoice_printer	device_name	varchar	2147483647
commission_source	direct_value	numeric	10,2
event	event_type	event_type	2147483647
credit_card_data	fee	numeric	10,2			0
invoice_field	field_name	varchar	2147483647
parameter_data	field_name	text	2147483647
transporter	freight_percentage	numeric	10,2
purchase_order	freight_type	purchase_order_freight_type	2147483647
receiving_order	freight_type	receiving_order_freight_type	2147483647			'fob-payment'::receiving_order_freight_type
individual	gender	individual_gender	2147483647
invoice_field	height	int8	19
invoice_layout	height	int8	19
account	id	uuid	2147483647			uuid_generate_v1()
account_transaction	id	uuid	2147483647			uuid_generate_v1()
address	id	uuid	2147483647			uuid_generate_v1()
attachment	id	uuid	2147483647			uuid_generate_v1()
bank_account	id	uuid	2147483647			uuid_generate_v1()
bill_option	id	uuid	2147483647			uuid_generate_v1()
branch	id	uuid	2147483647			uuid_generate_v1()
branch_station	id	uuid	2147483647			uuid_generate_v1()
branch_synchronization	id	bigserial	19		√	nextval('branch_synchronization_id_seq'::regclass)
calls	id	uuid	2147483647			uuid_generate_v1()
card_operation_cost	id	uuid	2147483647			uuid_generate_v1()
card_payment_device	id	uuid	2147483647			uuid_generate_v1()
cfop_data	id	uuid	2147483647			uuid_generate_v1()
check_data	id	uuid	2147483647			uuid_generate_v1()
city_location	id	bigserial	19		√	nextval('city_location_id_seq'::regclass)
client	id	uuid	2147483647			uuid_generate_v1()
client_category	id	uuid	2147483647			uuid_generate_v1()
client_category_price	id	uuid	2147483647			uuid_generate_v1()
client_salary_history	id	uuid	2147483647			uuid_generate_v1()
commission	id	uuid	2147483647			uuid_generate_v1()
commission_source	id	uuid	2147483647			uuid_generate_v1()
company	id	uuid	2147483647			uuid_generate_v1()
contact_info	id	uuid	2147483647			uuid_generate_v1()
cost_center	id	uuid	2147483647			uuid_generate_v1()
cost_center_entry	id	uuid	2147483647			uuid_generate_v1()
credit_card_data	id	uuid	2147483647			uuid_generate_v1()
credit_check_history	id	uuid	2147483647			uuid_generate_v1()
credit_provider	id	uuid	2147483647			uuid_generate_v1()
delivery	id	uuid	2147483647			uuid_generate_v1()
device_constant	id	uuid	2147483647			uuid_generate_v1()
device_settings	id	uuid	2147483647			uuid_generate_v1()
employee	id	uuid	2147483647			uuid_generate_v1()
employee_role	id	uuid	2147483647			uuid_generate_v1()
employee_role_history	id	uuid	2147483647			uuid_generate_v1()
event	id	bigserial	19		√	nextval('event_id_seq'::regclass)
fiscal_book_entry	id	uuid	2147483647			uuid_generate_v1()
fiscal_day_history	id	uuid	2147483647			uuid_generate_v1()
fiscal_day_tax	id	uuid	2147483647			uuid_generate_v1()
fiscal_sale_history	id	uuid	2147483647			uuid_generate_v1()
grid_attribute	id	uuid	2147483647			uuid_generate_v1()
grid_group	id	uuid	2147483647			uuid_generate_v1()
grid_option	id	uuid	2147483647			uuid_generate_v1()
image	id	uuid	2147483647			uuid_generate_v1()
individual	id	uuid	2147483647			uuid_generate_v1()
installed_plugin	id	uuid	2147483647			uuid_generate_v1()
inventory	id	uuid	2147483647			uuid_generate_v1()
inventory_item	id	uuid	2147483647			uuid_generate_v1()
invoice	id	uuid	2147483647			uuid_generate_v1()
invoice_field	id	uuid	2147483647			uuid_generate_v1()
invoice_item_cofins	id	uuid	2147483647			uuid_generate_v1()
invoice_item_icms	id	uuid	2147483647			uuid_generate_v1()
invoice_item_ipi	id	uuid	2147483647			uuid_generate_v1()
invoice_item_pis	id	uuid	2147483647			uuid_generate_v1()
invoice_layout	id	uuid	2147483647			uuid_generate_v1()
invoice_printer	id	uuid	2147483647			uuid_generate_v1()
loan	id	uuid	2147483647			uuid_generate_v1()
loan_item	id	uuid	2147483647			uuid_generate_v1()
login_user	id	uuid	2147483647			uuid_generate_v1()
military_data	id	uuid	2147483647			uuid_generate_v1()
parameter_data	id	uuid	2147483647			uuid_generate_v1()
payment	id	uuid	2147483647			uuid_generate_v1()
payment_category	id	uuid	2147483647			uuid_generate_v1()
payment_change_history	id	uuid	2147483647			uuid_generate_v1()
payment_comment	id	uuid	2147483647			uuid_generate_v1()
payment_flow_history	id	uuid	2147483647			uuid_generate_v1()
payment_group	id	uuid	2147483647			uuid_generate_v1()
payment_method	id	uuid	2147483647			uuid_generate_v1()
payment_renegotiation	id	uuid	2147483647			uuid_generate_v1()
person	id	uuid	2147483647			uuid_generate_v1()
plugin_egg	id	uuid	2147483647			uuid_generate_v1()
product	id	uuid	2147483647			uuid_generate_v1()
product_attribute	id	uuid	2147483647			uuid_generate_v1()
product_cofins_template	id	uuid	2147483647			uuid_generate_v1()
product_component	id	uuid	2147483647			uuid_generate_v1()
product_history	id	uuid	2147483647			uuid_generate_v1()
product_icms_template	id	uuid	2147483647			uuid_generate_v1()
product_ipi_template	id	uuid	2147483647			uuid_generate_v1()
product_manufacturer	id	uuid	2147483647			uuid_generate_v1()
product_option_map	id	uuid	2147483647			uuid_generate_v1()
product_pis_template	id	uuid	2147483647			uuid_generate_v1()
product_quality_test	id	uuid	2147483647			uuid_generate_v1()
product_stock_item	id	uuid	2147483647			uuid_generate_v1()
product_supplier_info	id	uuid	2147483647			uuid_generate_v1()
product_tax_template	id	uuid	2147483647			uuid_generate_v1()
production_item	id	uuid	2147483647			uuid_generate_v1()
production_item_quality_result	id	uuid	2147483647			uuid_generate_v1()
production_material	id	uuid	2147483647			uuid_generate_v1()
production_order	id	uuid	2147483647			uuid_generate_v1()
production_produced_item	id	uuid	2147483647			uuid_generate_v1()
production_service	id	uuid	2147483647			uuid_generate_v1()
profile_settings	id	uuid	2147483647			uuid_generate_v1()
purchase_item	id	uuid	2147483647			uuid_generate_v1()
purchase_order	id	uuid	2147483647			uuid_generate_v1()
purchase_receiving_map	id	uuid	2147483647			uuid_generate_v1()
quotation	id	uuid	2147483647			uuid_generate_v1()
quote_group	id	uuid	2147483647			uuid_generate_v1()
receiving_order	id	uuid	2147483647			uuid_generate_v1()
receiving_order_item	id	uuid	2147483647			uuid_generate_v1()
returned_sale	id	uuid	2147483647			uuid_generate_v1()
returned_sale_item	id	uuid	2147483647			uuid_generate_v1()
sale	id	uuid	2147483647			uuid_generate_v1()
sale_comment	id	uuid	2147483647			uuid_generate_v1()
sale_item	id	uuid	2147483647			uuid_generate_v1()
sale_token	id	uuid	2147483647			uuid_generate_v1()
sales_person	id	uuid	2147483647			uuid_generate_v1()
sellable	id	uuid	2147483647			uuid_generate_v1()
sellable_category	id	uuid	2147483647			uuid_generate_v1()
sellable_tax_constant	id	uuid	2147483647			uuid_generate_v1()
sellable_unit	id	uuid	2147483647			uuid_generate_v1()
service	id	uuid	2147483647			uuid_generate_v1()
stock_decrease	id	uuid	2147483647			uuid_generate_v1()
stock_decrease_item	id	uuid	2147483647			uuid_generate_v1()
stock_transaction_history	id	uuid	2147483647			uuid_generate_v1()
storable	id	uuid	2147483647			uuid_generate_v1()
storable_batch	id	uuid	2147483647			uuid_generate_v1()
supplier	id	uuid	2147483647			uuid_generate_v1()
system_table	id	bigserial	19		√	nextval('system_table_id_seq'::regclass)
till	id	uuid	2147483647			uuid_generate_v1()
till_entry	id	uuid	2147483647			uuid_generate_v1()
transaction_entry	id	bigserial	19		√	nextval('transaction_entry_id_seq'::regclass)
transfer_order	id	uuid	2147483647			uuid_generate_v1()
transfer_order_item	id	uuid	2147483647			uuid_generate_v1()
transporter	id	uuid	2147483647			uuid_generate_v1()
ui_field	id	uuid	2147483647			uuid_generate_v1()
ui_form	id	uuid	2147483647			uuid_generate_v1()
user_branch_access	id	uuid	2147483647			uuid_generate_v1()
user_profile	id	uuid	2147483647			uuid_generate_v1()
voter_data	id	uuid	2147483647			uuid_generate_v1()
work_order	id	uuid	2147483647			uuid_generate_v1()
work_order_category	id	uuid	2147483647			uuid_generate_v1()
work_order_history	id	uuid	2147483647			uuid_generate_v1()
work_order_item	id	uuid	2147483647			uuid_generate_v1()
work_order_package	id	uuid	2147483647			uuid_generate_v1()
work_order_package_item	id	uuid	2147483647			uuid_generate_v1()
work_permit_data	id	uuid	2147483647			uuid_generate_v1()
inventory	identifier	serial	10		√	nextval('inventory_identifier_seq'::regclass)
loan	identifier	serial	10		√	nextval('loan_identifier_seq'::regclass)
payment	identifier	serial	10		√	nextval('payment_identifier_seq'::regclass)
payment_renegotiation	identifier	serial	10		√	nextval('payment_renegotiation_identifier_seq'::regclass)
production_order	identifier	serial	10		√	nextval('production_order_identifier_seq'::regclass)
purchase_order	identifier	serial	10		√	nextval('purchase_order_identifier_seq'::regclass)
quotation	identifier	serial	10		√	nextval('quotation_identifier_seq'::regclass)
quote_group	identifier	serial	10		√	nextval('quote_group_identifier_seq'::regclass)
receiving_order	identifier	serial	10		√	nextval('receiving_order_identifier_seq'::regclass)
returned_sale	identifier	serial	10		√	nextval('returned_sale_identifier_seq'::regclass)
sale	identifier	serial	10		√	nextval('sale_identifier_seq'::regclass)
stock_decrease	identifier	serial	10		√	nextval('stock_decrease_identifier_seq'::regclass)
till_entry	identifier	serial	10		√	nextval('till_entry_identifier_seq'::regclass)
transfer_order	identifier	serial	10		√	nextval('transfer_order_identifier_seq'::regclass)
work_order	identifier	serial	10		√	nextval('work_order_identifier_seq'::regclass)
work_order_package	identifier	text	2147483647
commission_source	installments_value	numeric	10,2
inventory_item	inventory_id	uuid	2147483647
invoice	invoice_type	invoice_type	2147483647
cost_center	is_active	bool	1			true
inventory_item	is_adjusted	bool	1			false
work_order	is_rejected	bool	1			false
payment_change_history	last_status	payment_status	2147483647
individual	marital_status	marital_status	2147483647
attachment	name	text	2147483647
cost_center	name	text	2147483647
employee_role	name	text	2147483647
work_order_category	name	text	2147483647
payment_change_history	new_status	payment_status	2147483647
inventory	open_date	timestamp	29,6
purchase_order	open_date	timestamp	29,6
transfer_order	open_date	timestamp	29,6
account_transaction	operation_type	account_transaction_operation_type	2147483647
work_order_package_item	order_id	uuid	2147483647
work_order_package_item	package_id	uuid	2147483647
commission	payment_id	uuid	2147483647
payment	payment_type	payment_type	2147483647
installed_plugin	plugin_name	text	2147483647
plugin_egg	plugin_name	text	2147483647
branch_synchronization	policy	text	2147483647
inventory_item	product_id	uuid	2147483647
product_supplier_info	product_id	uuid	2147483647
transfer_order_item	quantity	numeric	20,3
inventory	responsible_id	uuid	2147483647
stock_transaction_history	responsible_id	uuid	2147483647
commission	sale_id	uuid	2147483647
sale_comment	sale_id	uuid	2147483647
transfer_order_item	sellable_id	uuid	2147483647
account_transaction	source_account_id	uuid	2147483647
transfer_order	source_branch_id	uuid	2147483647
work_order_package	source_branch_id	uuid	2147483647
transfer_order	source_responsible_id	uuid	2147483647
client	status	client_status	2147483647
credit_check_history	status	credit_check_status	2147483647
delivery	status	delivery_status	2147483647
employee	status	employee_status	2147483647
inventory	status	inventory_status	2147483647
loan	status	loan_status	2147483647
payment	status	payment_status	2147483647
production_order	status	production_order_status	2147483647
purchase_order	status	purchase_order_status	2147483647
receiving_order	status	receiving_order_status	2147483647
sale	status	sale_status	2147483647
sellable	status	sellable_status	2147483647
stock_decrease	status	stock_decrease_status	2147483647
supplier	status	supplier_status	2147483647
till	status	till_status	2147483647
transfer_order	status	transfer_order_status	2147483647
work_order	status	work_order_status	2147483647
work_order_package	status	work_order_package_status	2147483647
transfer_order_item	stock_cost	numeric	20,8			0
stock_transaction_history	storable_id	uuid	2147483647
storable_batch	storable_id	uuid	2147483647
product_supplier_info	supplier_id	uuid	2147483647
branch_synchronization	sync_time	timestamp	29,6
transaction_entry	te_time	timestamp	29,6
product_quality_test	test_type	product_quality_test_type	2147483647
till_entry	till_id	uuid	2147483647
stock_transaction_history	type	stock_transaction_history_type	2147483647
user_branch_access	user_id	uuid	2147483647
work_order_history	user_id	uuid	2147483647
login_user	username	text	2147483647
commission	value	numeric	20,2
work_order_history	what	text	2147483647
invoice_field	width	int8	19
invoice_layout	width	int8	19
work_order_history	work_order_id	uuid	2147483647
invoice_field	x	int8	19
invoice_field	y	int8	19