SchemaSpy Analysis of stoq_schema.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Fri Jun 10 16:06 BRT 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

stoq_schema.public contains 1179 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
branch_synchronization id bigserial 19  √  nextval('branch_synchronization_id_seq'::regclass)
city_location id bigserial 19  √  nextval('city_location_id_seq'::regclass)
event id bigserial 19  √  nextval('event_id_seq'::regclass)
system_table id bigserial 19  √  nextval('system_table_id_seq'::regclass)
transaction_entry id bigserial 19  √  nextval('transaction_entry_id_seq'::regclass)
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)
account_transaction account_id uuid 2147483647
bank_account account_id uuid 2147483647  √  null
account account_type account_type 2147483647
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_comment author_id uuid 2147483647
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
storable_batch batch_number text 2147483647
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
branch_synchronization branch_id uuid 2147483647
employee branch_id uuid 2147483647  √  null
fiscal_book_entry branch_id uuid 2147483647
inventory branch_id uuid 2147483647
invoice branch_id uuid 2147483647  √  null
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
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_cofins calculo product_cofins_template_calculo 2147483647 'percentage'::product_cofins_template_calculo
invoice_item_ipi calculo product_ipi_template_calculo 2147483647  √  null
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
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
card_operation_cost card_type credit_card_type 2147483647
credit_card_data card_type credit_card_type 2147483647
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
payment_category category_type payment_category_type 2147483647 'payable'::payment_category_type
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
commission commission_type int4 10
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
product consignment 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
cost_center_entry cost_center_id uuid 2147483647
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
storable_batch create_date timestamp 29,6
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
account_transaction date timestamp 29,6
calls date timestamp 29,6  √  null
client_salary_history date timestamp 29,6  √  null
event date timestamp 29,6
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
work_order_history date timestamp 29,6
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 description text 2147483647
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
event description varchar 2147483647
grid_attribute description text 2147483647  √  null
grid_group description text 2147483647  √  null
grid_option description text 2147483647  √  null
image description text 2147483647  √  null
invoice_layout description varchar 2147483647
invoice_printer description varchar 2147483647
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
payment_method destination_account_id uuid 2147483647
transfer_order destination_branch_id uuid 2147483647
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
invoice_printer device_name varchar 2147483647
device_constant device_settings_id uuid 2147483647  √  null
device_constant device_value bytea 2147483647  √  null
commission_source direct_value numeric 10,2
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
event event_type event_type 2147483647
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 numeric 10,2 0
credit_card_data fee_value numeric 20,2  √  0
invoice_field field_name varchar 2147483647
parameter_data field_name text 2147483647
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
transporter freight_percentage numeric 10,2
receiving_order freight_total numeric 20,2  √  null
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
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
invoice_field height int8 19
invoice_layout height int8 19
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
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()
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()
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()
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()
till id uuid 2147483647 uuid_generate_v1()
till_entry id uuid 2147483647 uuid_generate_v1()
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()
credit_check_history identifier text 2147483647  √  null
work_order_package identifier text 2147483647
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
commission_source installments_value numeric 10,2
payment interest numeric 20,2  √  null
product internal_use bool 1  √  false
inventory_item inventory_id uuid 2147483647
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
invoice invoice_type invoice_type 2147483647
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
cost_center is_active bool 1 true
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
inventory_item is_adjusted bool 1 false
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
work_order is_rejected 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
payment_change_history last_status payment_status 2147483647
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
individual marital_status marital_status 2147483647
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
attachment name text 2147483647
branch_station name text 2147483647  √  null
client_category name text 2147483647  √  null
cost_center name text 2147483647
employee_role name text 2147483647
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
work_order_category name text 2147483647
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
payment_change_history new_status payment_status 2147483647
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
inventory open_date timestamp 29,6
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
purchase_order open_date timestamp 29,6
sale open_date timestamp 29,6  √  null
transfer_order open_date timestamp 29,6
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
account_transaction operation_type account_transaction_operation_type 2147483647
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
work_order_package_item order_id uuid 2147483647
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
work_order_package_item package_id uuid 2147483647
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
commission payment_id uuid 2147483647
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 payment_type payment_type 2147483647
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_name text 2147483647
plugin_egg plugin_name text 2147483647
installed_plugin plugin_version int4 10  √  null
branch_synchronization policy text 2147483647
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
inventory_item product_id uuid 2147483647
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
product_supplier_info product_id uuid 2147483647
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
transfer_order_item quantity numeric 20,3
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
inventory responsible_id uuid 2147483647
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
stock_transaction_history responsible_id uuid 2147483647
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
commission sale_id uuid 2147483647
fiscal_sale_history sale_id uuid 2147483647  √  null
returned_sale sale_id uuid 2147483647  √  null
sale_comment sale_id uuid 2147483647
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
transfer_order_item sellable_id uuid 2147483647
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
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
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
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
payment_renegotiation status int4 10  √  null
production_order status production_order_status 2147483647
purchase_order status purchase_order_status 2147483647
receiving_order status receiving_order_status 2147483647
returned_sale status returned_sale_status 2147483647  √  null
sale status sale_status 2147483647
sale_token status sale_token_status 2147483647  √  'available'::sale_token_status
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
product_stock_item stock_cost numeric 20,8  √  null
stock_transaction_history stock_cost numeric 20,8  √  null
transfer_order_item stock_cost numeric 20,8 0
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
stock_transaction_history storable_id uuid 2147483647
storable_batch storable_id uuid 2147483647
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
product_supplier_info supplier_id uuid 2147483647
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
branch_synchronization sync_time timestamp 29,6
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()
transaction_entry te_time timestamp 29,6
production_item_quality_result test_passed bool 1  √  null
production_produced_item test_passed bool 1  √  null
product_quality_test test_type product_quality_test_type 2147483647
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
till_entry till_id uuid 2147483647
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
stock_transaction_history type stock_transaction_history_type 2147483647
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
user_branch_access user_id uuid 2147483647
work_order_history user_id uuid 2147483647
profile_settings user_profile_id uuid 2147483647  √  null
login_user username text 2147483647
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
commission value numeric 20,2
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
work_order_history what text 2147483647
invoice_field width int8 19
invoice_layout width int8 19
product width numeric 10,2  √  null
work_order_history work_order_id uuid 2147483647
employee workpermit_data_id uuid 2147483647  √  null
invoice_field x int8 19
invoice_field y int8 19
voter_data zone text 2147483647  √  null