SchemaSpy Analysis of jdahlin.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Sex Jun 10 16:28 BRT 2011
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
jdahlin.public contains 941 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
allow_fraction sellable_unit bool 1  √  true
bc_include_ipi product_icms_template bool 1  √  true
bc_include_ipi sale_item_icms bool 1  √  true
bc_st_include_ipi product_icms_template bool 1  √  true
bc_st_include_ipi sale_item_icms bool 1  √  true
consigned purchase_order bool 1  √  false
consignment product bool 1 false
has_permission profile_settings bool 1  √  null
is_active branch_station bool 1  √  null
is_active device_settings bool 1  √  null
is_active employee_role_history bool 1  √  null
is_active payment_method bool 1  √  null
is_active person_adapt_to_bank_branch bool 1  √  null
is_active person_adapt_to_branch bool 1  √  null
is_active person_adapt_to_company bool 1  √  null
is_active person_adapt_to_credit_provider bool 1  √  null
is_active person_adapt_to_employee bool 1  √  null
is_active person_adapt_to_individual bool 1  √  null
is_active person_adapt_to_sales_person bool 1  √  null
is_active person_adapt_to_supplier bool 1  √  null
is_active person_adapt_to_transporter bool 1  √  null
is_active person_adapt_to_user bool 1  √  null
is_editable parameter_data bool 1  √  null
is_main_address address bool 1  √  null
is_main_supplier product_supplier_info bool 1  √  null
is_reversal fiscal_book_entry bool 1  √  null
is_valid_model device_constant bool 1  √  null
account_type account int4 10  √  null
auth credit_card_data int4 10  √  null
bank_id bank_account int4 10  √  null
calculo product_ipi_template int4 10  √  null
calculo sale_item_ipi int4 10  √  null
card_type credit_card_data int4 10  √  null
closing_day card_installment_settings int4 10  √  null
closing_day payment_method int4 10  √  null
closing_day person_adapt_to_credit_provider int4 10  √  null
comission_type person_adapt_to_sales_person int4 10  √  null
commission_type commission int4 10
constant_enum device_constant int4 10  √  null
constant_type device_constant int4 10  √  null
coo fiscal_sale_history int4 10  √  null
coupon_end fiscal_day_history int4 10  √  null
coupon_id sale int4 10  √  null
coupon_start fiscal_day_history int4 10  √  null
cro fiscal_day_history int4 10  √  null
crt person_adapt_to_branch int4 10  √  1
crz fiscal_day_history int4 10  √  null
csosn product_icms_template int4 10  √  null
csosn sale_item_icms int4 10  √  null
cst product_icms_template int4 10  √  null
cst product_ipi_template int4 10  √  null
cst sale_item_icms int4 10  √  null
cst sale_item_ipi int4 10  √  null
days_late person_adapt_to_client int4 10  √  null
dependent_person_number person_adapt_to_employee int4 10  √  null
device device_settings int4 10  √  null
document_counter fiscal_sale_history int4 10  √  null
document_type fiscal_sale_history int4 10  √  null
entry_type fiscal_book_entry int4 10  √  null
freight_type purchase_order int4 10  √  null
freight_type receiving_order int4 10  √  0
gender person_adapt_to_individual int4 10  √  null
generation system_table int4 10  √  null
id account serial 10  √  nextval('account_id_seq'::regclass)
account.parent_id account_parent_id_fkey
account_transaction.account_id account_transaction_account_id_fkey
account_transaction.source_account_id account_transaction_source_account_id_fkey
payment_method.destination_account_id payment_method_destination_account_id_fkey
id account_transaction serial 10  √  nextval('account_transaction_id_seq'::regclass)
installments credit_card_data int4 10  √  1
invoice_number fiscal_book_entry int4 10  √  null
invoice_number inventory int4 10  √  null
invoice_number receiving_order int4 10  √  null
invoice_number renegotiation_data int4 10  √  null
invoice_number sale int4 10  √  null
last_status payment_change_history int4 10  √  null
lead_time product_supplier_info int4 10  √  1
marital_status person_adapt_to_individual int4 10  √  null
max_installments payment_method int4 10  √  null
max_installments person_adapt_to_credit_provider int4 10  √  null
max_installments_number card_installments_provider_details int4 10  √  null
max_installments_number card_installments_store_details int4 10  √  null
mod_bc product_icms_template int4 10  √  null
mod_bc sale_item_icms int4 10  √  null
mod_bc_st product_icms_template int4 10  √  null
mod_bc_st sale_item_icms int4 10  √  null
new_status payment_change_history int4 10  √  null
nsu credit_card_data int4 10  √  null
orig product_icms_template int4 10  √  null
orig sale_item_icms int4 10  √  null
paid_payments payment_flow_history int4 10  √  null
patchlevel system_table int4 10  √  null
payment_day card_installment_settings int4 10  √  null
payment_day payment_method int4 10  √  null
payment_day person_adapt_to_credit_provider int4 10  √  null
payment_id till_entry int4 10  √  null
plugin_version installed_plugin int4 10  √  null
provider_type person_adapt_to_credit_provider int4 10  √  null
q_selo product_ipi_template int4 10  √  null
q_selo sale_item_ipi int4 10  √  null
receive_days debit_card_details int4 10  √  null
received_payments payment_flow_history int4 10  √  null
serial_id fiscal_day_history int4 10  √  null
service_invoice_number sale int4 10  √  null
station_id transaction_entry int4 10  √  null
branch_station.id transaction_entry_station_id_fkey
status inventory int4 10  √  null
status loan int4 10  √  null
status payment int4 10  √  null
status payment_group int4 10  √  null
status payment_renegotiation int4 10  √  null
status person_adapt_to_client int4 10  √  null
status person_adapt_to_employee int4 10  √  null
status person_adapt_to_supplier int4 10  √  null
status production_order int4 10  √  null
status purchase_order int4 10  √  null
status receiving_order int4 10  √  null
status sale int4 10  √  null
status sellable int4 10  √  null
status stock_decrease int4 10  √  null
status till int4 10  √  null
status transfer_order int4 10  √  null
streetnumber address int4 10  √  null
tax_type product_tax_template int4 10  √  null
tax_type sellable_tax_constant int4 10  √  null
to_pay_payments payment_flow_history int4 10  √  null
to_receive_payments payment_flow_history int4 10  √  null
type device_settings int4 10  √  null
type transaction_entry int4 10  √  null
unit_index sellable_unit int4 10  √  null
user_id transaction_entry int4 10  √  null
person_adapt_to_user.id transaction_entry_user_id_fkey
average_cost sale_item numeric 10,2  √  0
balance_expected payment_flow_history numeric 10,2  √  null
balance_real payment_flow_history numeric 10,2  √  null
base_price sale_item numeric 10,2  √  null
base_value payment numeric 10,2  √  null
comission person_adapt_to_sales_person numeric 10,2  √  null
commission base_sellable_info numeric 10,2  √  null
constant_value device_constant numeric 10,2  √  null
credit_fee person_adapt_to_credit_provider numeric 10,2 0
credit_installments_provider_fee person_adapt_to_credit_provider numeric 10,2 0
credit_installments_store_fee person_adapt_to_credit_provider numeric 10,2 0
credit_limit person_adapt_to_client numeric 10,2  √  0
daily_penalty payment_method numeric 10,2  √  null
debit_fee person_adapt_to_credit_provider numeric 10,2 0
debit_pre_dated_fee person_adapt_to_credit_provider numeric 10,2 0
depth product numeric 10,2  √  null
direct_value commission_source numeric 10,2
discount payment numeric 10,2  √  null
discount_value payment_renegotiation numeric 10,2  √  null
discount_value purchase_order numeric 10,2  √  null
discount_value receiving_order numeric 10,2  √  null
discount_value sale numeric 10,2  √  null
entrance_value credit_card_data numeric 10,2  √  0
expected_freight purchase_order numeric 10,2  √  null
expense_value receiving_order numeric 10,2  √  null
fee credit_card_data numeric 10,2 0
fee_value credit_card_data numeric 10,2  √  0
final_cash_amount till numeric 10,2  √  null
freight_percentage person_adapt_to_transporter numeric 10,2
freight_total receiving_order numeric 10,2  √  null
height product numeric 10,2  √  null
icms product_supplier_info numeric 10,2  √  null
icms_total receiving_order numeric 10,2  √  null
icms_value fiscal_book_entry numeric 10,2  √  null
initial_cash_amount till numeric 10,2  √  null
installments_value commission_source numeric 10,2
interest payment numeric 10,2  √  null
interest payment_method numeric 10,2  √  null
invoice_total receiving_order numeric 10,2  √  null
ipi_total receiving_order numeric 10,2  √  null
ipi_value fiscal_book_entry numeric 10,2  √  null
iss_value fiscal_book_entry numeric 10,2  √  null
max_discount base_sellable_info numeric 10,2  √  null
on_sale_price on_sale_info numeric 10,2  √  null
p_cred_sn product_icms_template numeric 10,2  √  null
p_cred_sn sale_item_icms numeric 10,2  √  null
p_icms product_icms_template numeric 10,2  √  null
p_icms sale_item_icms numeric 10,2  √  null
p_icms_st product_icms_template numeric 10,2  √  null
p_icms_st sale_item_icms numeric 10,2  √  null
p_ipi product_ipi_template numeric 10,2  √  null
p_ipi sale_item_ipi numeric 10,2  √  null
p_mva_st product_icms_template numeric 10,2  √  null
p_mva_st sale_item_icms numeric 10,2  √  null
p_red_bc product_icms_template numeric 10,2  √  null
p_red_bc sale_item_icms numeric 10,2  √  null
p_red_bc_st product_icms_template numeric 10,2  √  null
p_red_bc_st sale_item_icms numeric 10,2  √  null
paid payment_flow_history numeric 10,2  √  null
paid_total renegotiation_data numeric 10,2  √  null
paid_value payment numeric 10,2  √  null
penalty payment numeric 10,2  √  null
penalty_value renegotiation_data numeric 10,2  √  null
period_total fiscal_day_history numeric 10,2  √  null
price base_sellable_info numeric 10,2  √  null
price loan_item numeric 10,2  √  null
price sale_item numeric 10,2  √  null
received payment_flow_history numeric 10,2  √  null
salary employee_role_history numeric 10,2  √  null
salary person_adapt_to_employee numeric 10,2  √  null
salesperson_commission sellable_category numeric 10,2  √  null
secure_value receiving_order numeric 10,2  √  null
stock_cost product_stock_item numeric 10,2  √  null
suggested_markup sellable_category numeric 10,2  √  null
surcharge_value payment_renegotiation numeric 10,2  √  null
surcharge_value purchase_order numeric 10,2  √  null
surcharge_value receiving_order numeric 10,2  √  null
surcharge_value sale numeric 10,2  √  null
tax_total fiscal_day_history numeric 10,2  √  null
tax_value sellable_tax_constant numeric 10,2  √  null
to_pay payment_flow_history numeric 10,2  √  null
to_receive payment_flow_history numeric 10,2  √  null
total fiscal_day_history numeric 10,2  √  null
total payment_renegotiation numeric 10,2  √  null
total_amount sale numeric 10,2  √  null
v_bc sale_item_icms numeric 10,2  √  null
v_bc sale_item_ipi numeric 10,2  √  null
v_bc_st sale_item_icms numeric 10,2  √  null
v_bc_st_ret sale_item_icms numeric 10,2  √  null
v_cred_icms_sn sale_item_icms numeric 10,2  √  null
v_icms sale_item_icms numeric 10,2  √  null
v_icms_st sale_item_icms numeric 10,2  √  null
v_icms_st_ret sale_item_icms numeric 10,2  √  null
v_ipi sale_item_ipi numeric 10,2  √  null
value commission numeric 10,2
value fiscal_day_tax numeric 10,2  √  null
value payment numeric 10,2  √  null
value till_entry numeric 10,2  √  null
weight product numeric 10,2  √  null
width product numeric 10,2  √  null
actual_quantity inventory_item numeric 10,3  √  null
allocated production_material numeric 10,3  √  0
consumed production_material numeric 10,3  √  0
logic_quantity product_stock_item numeric 10,3  √  null
lost production_item numeric 10,3  √  0
lost production_material numeric 10,3  √  0
maximum_quantity product_adapt_to_storable numeric 10,3  √  0
minimum_purchase product_supplier_info numeric 10,3  √  1
minimum_quantity product_adapt_to_storable numeric 10,3  √  0
needed production_material numeric 10,3  √  null
produced production_item numeric 10,3  √  0
quantity delivery_item numeric 10,3  √  null
quantity loan_item numeric 10,3  √  null
quantity product_component numeric 10,3  √  null
quantity product_stock_item numeric 10,3  √  null
quantity production_item numeric 10,3  √  null
quantity production_service numeric 10,3  √  null
quantity purchase_item numeric 10,3  √  null
quantity receiving_order_item numeric 10,3  √  null
quantity sale_item numeric 10,3  √  null
quantity stock_decrease_item numeric 10,3  √  null
quantity transfer_order_item numeric 10,3
quantity_consumed product_history numeric 10,3  √  null
quantity_decreased product_history numeric 10,3  √  null
quantity_lost product_history numeric 10,3  √  null
quantity_produced product_history numeric 10,3  √  null
quantity_received product_history numeric 10,3  √  null
quantity_received purchase_item numeric 10,3  √  null
quantity_returned purchase_item numeric 10,3  √  0
quantity_sold product_history numeric 10,3  √  null
quantity_sold purchase_item numeric 10,3  √  0
quantity_transfered product_history numeric 10,3  √  null
recorded_quantity inventory_item numeric 10,3  √  null
return_quantity loan_item numeric 10,3  √  null
sale_quantity loan_item numeric 10,3  √  null
to_make production_material numeric 10,3  √  null
to_purchase production_material numeric 10,3  √  null
value account_transaction numeric 10,3  √  null
base_cost product_supplier_info numeric 10,4  √  null
base_cost purchase_item numeric 10,4  √  null
cost purchase_item numeric 10,4  √  null
cost receiving_order_item numeric 10,4  √  null
cost sellable numeric 10,4  √  null
monthly_fee person_adapt_to_credit_provider numeric 10,4 0
product_cost inventory_item numeric 10,4  √  null
q_unid product_ipi_template numeric 10,4  √  null
q_unid sale_item_ipi numeric 10,4  √  null
v_unid sale_item_ipi numeric 10,4  √  null
emission_date fiscal_day_history date 13  √  null
account_id account_transaction int8 19
account.id account_transaction_account_id_fkey
attendant_id calls int8 19  √  null
person_adapt_to_user.id calls_attendant_id_fkey
author_id payment_comment int8 19  √  null
person_adapt_to_user.id payment_comment_author_id_fkey
bank_account_id person_adapt_to_employee int8 19  √  null
bank_account.id person_adapt_to_employee_bank_account_id_fkey
bank_data_id check_data int8 19  √  null
bank_account.id check_data_bank_data_id_fkey
bank_id person_adapt_to_bank_branch int8 19  √  null
bank.id person_adapt_to_bank_branch_bank_id_fkey
base_sellable_info_id sellable int8 19  √  null
base_sellable_info.id sellable_base_sellable_info_id_fkey
birth_location_id person_adapt_to_individual int8 19  √  null
city_location.id person_adapt_to_individual_birth_location_id_fkey
branch_id branch_station int8 19  √  null
person_adapt_to_branch.id branch_station_branch_id_fkey
branch_id branch_synchronization int8 19  √  null
person_adapt_to_branch.id branch_synchronization_branch_id_fkey
branch_id fiscal_book_entry int8 19  √  null
person_adapt_to_branch.id fiscal_book_entry_branch_id_fkey
branch_id inventory int8 19
person_adapt_to_branch.id inventory_branch_id_fkey
branch_id loan int8 19  √  null
person_adapt_to_branch.id loan_branch_id_fkey
branch_id payment_renegotiation int8 19  √  null
person_adapt_to_branch.id payment_renegotiation_branch_id_fkey
branch_id product_history int8 19  √  null
person_adapt_to_branch.id product_history_branch_id_fkey
branch_id product_stock_item int8 19  √  null
person_adapt_to_branch.id product_stock_item_branch_id_fkey
branch_id production_order int8 19  √  null
person_adapt_to_branch.id production_order_branch_id_fkey
branch_id purchase_order int8 19  √  null
person_adapt_to_branch.id purchase_order_branch_id_fkey
branch_id receiving_order int8 19  √  null
person_adapt_to_branch.id receiving_order_branch_id_fkey
branch_id sale int8 19  √  null
person_adapt_to_branch.id sale_branch_id_fkey
branch_id stock_decrease int8 19  √  null
person_adapt_to_branch.id stock_decrease_branch_id_fkey
category_id commission_source int8 19  √  null
sellable_category.id commission_source_category_id_fkey
category_id payment int8 19  √  null
payment_category.id payment_category_id_fkey
category_id person_adapt_to_client int8 19  √  null
client_category.id person_adapt_to_client_category_id_fkey
category_id sellable int8 19  √  null
sellable_category.id sellable_category_id_fkey
category_id sellable_category int8 19  √  null
sellable_category.id sellable_category_category_id_fkey
cfop_data_id inventory_item int8 19  √  null
cfop_data.id inventory_item_cfop_data_id_fkey
cfop_id fiscal_book_entry int8 19  √  null
cfop_data.id fiscal_book_entry_cfop_id_fkey
cfop_id receiving_order int8 19  √  null
cfop_data.id receiving_order_cfop_id_fkey
cfop_id sale int8 19  √  null
cfop_data.id sale_cfop_id_fkey
cfop_id sale_item int8 19  √  null
cfop_data.id sale_item_cfop_id_fkey
cfop_id stock_decrease int8 19  √  null
cfop_data.id stock_decrease_cfop_id_fkey
city_location_id address int8 19  √  null
city_location.id address_city_location_id_fkey
client_id loan int8 19  √  null
person_adapt_to_client.id loan_client_id_fkey
client_id payment_renegotiation int8 19  √  null
person_adapt_to_client.id payment_renegotiation_client_id_fkey
client_id sale int8 19  √  null
person_adapt_to_client.id sale_client_id_fkey
component_id product_component int8 19  √  null
product.id product_component_component_id_fkey
default_sale_cfop_id sellable int8 19  √  null
cfop_data.id sellable_default_sale_cfop_id_fkey
delivery_id delivery_item int8 19  √  null
sale_item_adapt_to_delivery.id delivery_item_delivery_id_fkey
destination_account_id payment_method int8 19
account.id payment_method_destination_account_id_fkey
destination_branch_id transfer_order int8 19
person_adapt_to_branch.id transfer_order_destination_branch_id_fkey
destination_responsible_id transfer_order int8 19
person_adapt_to_employee.id transfer_order_destination_responsible_id_fkey
device_settings_id device_constant int8 19  √  null
device_settings.id device_constant_device_settings_id_fkey
drawee_id fiscal_book_entry int8 19  √  null
person.id fiscal_book_entry_drawee_id_fkey
employee_id employee_role_history int8 19  √  null
person_adapt_to_employee.id employee_role_history_employee_id_fkey
fiscal_day_history_id fiscal_day_tax int8 19  √  null
fiscal_day_history.id fiscal_day_tax_fiscal_day_history_id_fkey
group_id payment int8 19  √  null
payment_group.id payment_group_id_fkey
group_id payment_renegotiation int8 19  √  null
payment_group.id payment_renegotiation_group_id_fkey
group_id purchase_order int8 19  √  null
payment_group.id purchase_order_group_id_fkey
group_id quotation int8 19  √  null
quote_group.id quotation_group_id_fkey
group_id sale int8 19  √  null
payment_group.id sale_group_id_fkey
height invoice_field int8 19
height invoice_layout int8 19
icms_info_id sale_item int8 19  √  null
sale_item_icms.id sale_item_icms_info_id_fkey
icms_template_id product int8 19  √  null
product_icms_template.id product_icms_template_id_fkey
id address bigserial 19  √  nextval('address_id_seq'::regclass)
id bank bigserial 19  √  nextval('bank_id_seq'::regclass)
person_adapt_to_bank_branch.bank_id person_adapt_to_bank_branch_bank_id_fkey
id bank_account bigserial 19  √  nextval('bank_account_id_seq'::regclass)
check_data.bank_data_id check_data_bank_data_id_fkey
person_adapt_to_employee.bank_account_id person_adapt_to_employee_bank_account_id_fkey
id base_sellable_info bigserial 19  √  nextval('base_sellable_info_id_seq'::regclass)
sellable.base_sellable_info_id sellable_base_sellable_info_id_fkey
id branch_station bigserial 19  √  nextval('branch_station_id_seq'::regclass)
account.station_id account_station_id_fkey
device_settings.station_id device_settings_station_id_fkey
fiscal_day_history.station_id fiscal_day_history_station_id_fkey
invoice_printer.station_id invoice_printer_station_id_fkey
till.station_id till_station_id_fkey
transaction_entry.station_id transaction_entry_station_id_fkey
id branch_synchronization bigserial 19  √  nextval('branch_synchronization_id_seq'::regclass)
id calls bigserial 19  √  nextval('calls_id_seq'::regclass)
id card_installment_settings bigserial 19  √  nextval('card_installment_settings_id_seq'::regclass)
card_installments_provider_details.installment_settings_id card_installments_provider_details_installment_settings_id_fkey
card_installments_store_details.installment_settings_id card_installments_store_details_installment_settings_id_fkey
credit_card_details.installment_settings_id credit_card_details_installment_settings_id_fkey
id card_installments_provider_details bigserial 19  √  nextval('card_installments_provider_details_id_seq'::regclass)
id card_installments_store_details bigserial 19  √  nextval('card_installments_store_details_id_seq'::regclass)
id cfop_data bigserial 19  √  nextval('cfop_data_id_seq'::regclass)
fiscal_book_entry.cfop_id fiscal_book_entry_cfop_id_fkey
inventory_item.cfop_data_id inventory_item_cfop_data_id_fkey
receiving_order.cfop_id receiving_order_cfop_id_fkey
sale.cfop_id sale_cfop_id_fkey
sale_item.cfop_id sale_item_cfop_id_fkey
sellable.default_sale_cfop_id sellable_default_sale_cfop_id_fkey
stock_decrease.cfop_id stock_decrease_cfop_id_fkey
id check_data bigserial 19  √  nextval('check_data_id_seq'::regclass)
id city_location bigserial 19  √  nextval('city_location_id_seq'::regclass)
address.city_location_id address_city_location_id_fkey
person_adapt_to_individual.birth_location_id person_adapt_to_individual_birth_location_id_fkey
id client_category bigserial 19  √  nextval('client_category_id_seq'::regclass)
person_adapt_to_client.category_id person_adapt_to_client_category_id_fkey
id commission bigserial 19  √  nextval('commission_id_seq'::regclass)
id commission_source bigserial 19  √  nextval('commission_source_id_seq'::regclass)
id credit_card_data bigserial 19  √  nextval('credit_card_data_id_seq'::regclass)
id credit_card_details bigserial 19  √  nextval('credit_card_details_id_seq'::regclass)
id debit_card_details bigserial 19  √  nextval('debit_card_details_id_seq'::regclass)
id delivery_item bigserial 19  √  nextval('delivery_item_id_seq'::regclass)
id device_constant bigserial 19  √  nextval('device_constant_id_seq'::regclass)
id device_settings bigserial 19  √  nextval('device_settings_id_seq'::regclass)
device_constant.device_settings_id device_constant_device_settings_id_fkey
id employee_role bigserial 19  √  nextval('employee_role_id_seq'::regclass)
employee_role_history.role_id employee_role_history_role_id_fkey
person_adapt_to_employee.role_id person_adapt_to_employee_role_id_fkey
id employee_role_history bigserial 19  √  nextval('employee_role_history_id_seq'::regclass)
id fiscal_book_entry bigserial 19  √  nextval('fiscal_book_entry_id_seq'::regclass)
id fiscal_day_history bigserial 19  √  nextval('fiscal_day_history_id_seq'::regclass)
fiscal_day_tax.fiscal_day_history_id fiscal_day_tax_fiscal_day_history_id_fkey
id fiscal_day_tax bigserial 19  √  nextval('fiscal_day_tax_id_seq'::regclass)
id fiscal_sale_history bigserial 19  √  nextval('fiscal_sale_history_id_seq'::regclass)
id installed_plugin bigserial 19  √  nextval('installed_plugin_id_seq'::regclass)
id inventory bigserial 19  √  nextval('inventory_id_seq'::regclass)
inventory_item.inventory_id inventory_item_inventory_id_fkey
id inventory_item bigserial 19  √  nextval('inventory_item_id_seq'::regclass)
id invoice_field bigserial 19  √  nextval('invoice_field_id_seq'::regclass)
id invoice_layout bigserial 19  √  nextval('invoice_layout_id_seq'::regclass)
invoice_field.layout_id invoice_field_layout_id_fkey
invoice_printer.layout_id invoice_printer_layout_id_fkey
id invoice_printer bigserial 19  √  nextval('invoice_printer_id_seq'::regclass)
id liaison bigserial 19  √  nextval('liaison_id_seq'::regclass)
id loan bigserial 19  √  nextval('loan_id_seq'::regclass)
loan_item.loan_id loan_item_loan_id_fkey
id loan_item bigserial 19  √  nextval('loan_item_id_seq'::regclass)
id military_data bigserial 19  √  nextval('military_data_id_seq'::regclass)
person_adapt_to_employee.military_data_id person_adapt_to_employee_military_data_id_fkey
id on_sale_info bigserial 19  √  nextval('on_sale_info_id_seq'::regclass)
sellable.on_sale_info_id sellable_on_sale_info_id_fkey
id parameter_data bigserial 19  √  nextval('parameter_data_id_seq'::regclass)
id payment bigserial 19  √  nextval('payment_id_seq'::regclass)
account_transaction.payment_id account_transaction_payment_id_fkey
check_data.payment_id check_data_payment_id_fkey
commission.payment_id commission_payment_id_fkey
credit_card_data.payment_id credit_card_data_payment_id_fkey
payment_adapt_to_in_payment.original_id payment_adapt_to_in_payment_original_id_fkey
payment_adapt_to_out_payment.original_id payment_adapt_to_out_payment_original_id_fkey
payment_change_history.payment_id payment_change_history_payment_id_fkey
payment_comment.payment_id payment_comment_payment_id_fkey
id payment_adapt_to_in_payment bigserial 19  √  nextval('payment_adapt_to_in_payment_id_seq'::regclass)
id payment_adapt_to_out_payment bigserial 19  √  nextval('payment_adapt_to_out_payment_id_seq'::regclass)
id payment_category bigserial 19  √  nextval('payment_category_id_seq'::regclass)
payment.category_id payment_category_id_fkey
id payment_change_history bigserial 19  √  nextval('payment_change_history_id_seq'::regclass)
id payment_comment bigserial 19  √  nextval('payment_comment_id_seq'::regclass)
id payment_flow_history bigserial 19  √  nextval('payment_flow_history_id_seq'::regclass)
id payment_group bigserial 19  √  nextval('payment_group_id_seq'::regclass)
fiscal_book_entry.payment_group_id fiscal_book_entry_payment_group_id_fkey
payment.group_id payment_group_id_fkey
payment_renegotiation.group_id payment_renegotiation_group_id_fkey
purchase_order.group_id purchase_order_group_id_fkey
sale.group_id sale_group_id_fkey
id payment_method bigserial 19  √  nextval('payment_method_id_seq'::regclass)
payment.method_id payment_method_id_fkey
id payment_renegotiation bigserial 19  √  nextval('payment_renegotiation_id_seq'::regclass)
payment_group.renegotiation_id payment_group_renegotiation_id_fkey
id person bigserial 19  √  nextval('person_id_seq'::regclass)
address.person_id address_person_id_fkey
calls.person_id calls_person_id_fkey
fiscal_book_entry.drawee_id fiscal_book_entry_drawee_id_fkey
liaison.person_id liaison_person_id_fkey
payment_group.payer_id payment_group_payer_id_fkey
payment_group.recipient_id payment_group_recipient_id_fkey
person_adapt_to_bank_branch.original_id person_adapt_to_bank_branch_original_id_fkey
person_adapt_to_branch.original_id person_adapt_to_branch_original_id_fkey
person_adapt_to_client.original_id person_adapt_to_client_original_id_fkey
person_adapt_to_company.original_id person_adapt_to_company_original_id_fkey
person_adapt_to_credit_provider.original_id person_adapt_to_credit_provider_original_id_fkey
person_adapt_to_employee.original_id person_adapt_to_employee_original_id_fkey
person_adapt_to_individual.original_id person_adapt_to_individual_original_id_fkey
person_adapt_to_sales_person.original_id person_adapt_to_sales_person_original_id_fkey
person_adapt_to_supplier.original_id person_adapt_to_supplier_original_id_fkey
person_adapt_to_transporter.original_id person_adapt_to_transporter_original_id_fkey
person_adapt_to_user.original_id person_adapt_to_user_original_id_fkey
renegotiation_data.responsible_id renegotiation_data_responsible_id_fkey
id person_adapt_to_bank_branch bigserial 19  √  nextval('person_adapt_to_bank_branch_id_seq'::regclass)
id person_adapt_to_branch bigserial 19  √  nextval('person_adapt_to_branch_id_seq'::regclass)
branch_station.branch_id branch_station_branch_id_fkey
branch_synchronization.branch_id branch_synchronization_branch_id_fkey
fiscal_book_entry.branch_id fiscal_book_entry_branch_id_fkey
inventory.branch_id inventory_branch_id_fkey
loan.branch_id loan_branch_id_fkey
payment_renegotiation.branch_id payment_renegotiation_branch_id_fkey
product_history.branch_id product_history_branch_id_fkey
product_stock_item.branch_id product_stock_item_branch_id_fkey
production_order.branch_id production_order_branch_id_fkey
purchase_order.branch_id purchase_order_branch_id_fkey
receiving_order.branch_id receiving_order_branch_id_fkey
sale.branch_id sale_branch_id_fkey
stock_decrease.branch_id stock_decrease_branch_id_fkey
transfer_order.destination_branch_id transfer_order_destination_branch_id_fkey
transfer_order.source_branch_id transfer_order_source_branch_id_fkey
id person_adapt_to_client bigserial 19  √  nextval('person_adapt_to_client_id_seq'::regclass)
loan.client_id loan_client_id_fkey
payment_renegotiation.client_id payment_renegotiation_client_id_fkey
sale.client_id sale_client_id_fkey
id person_adapt_to_company bigserial 19  √  nextval('person_adapt_to_company_id_seq'::regclass)
id person_adapt_to_credit_provider bigserial 19  √  nextval('person_adapt_to_credit_provider_id_seq'::regclass)
credit_card_data.provider_id credit_card_data_provider_id_fkey
id person_adapt_to_employee bigserial 19  √  nextval('person_adapt_to_employee_id_seq'::regclass)
employee_role_history.employee_id employee_role_history_employee_id_fkey
person_adapt_to_branch.manager_id person_adapt_to_branch_manager_id_fkey
production_order.responsible_id production_order_responsible_id_fkey
stock_decrease.removed_by_id stock_decrease_removed_by_id_fkey
transfer_order.destination_responsible_id transfer_order_destination_responsible_id_fkey
transfer_order.source_responsible_id transfer_order_source_responsible_id_fkey
id person_adapt_to_individual bigserial 19  √  nextval('person_adapt_to_individual_id_seq'::regclass)
id person_adapt_to_sales_person bigserial 19  √  nextval('person_adapt_to_sales_person_id_seq'::regclass)
commission.salesperson_id commission_salesperson_id_fkey
sale.salesperson_id sale_salesperson_id_fkey
id person_adapt_to_supplier bigserial 19  √  nextval('person_adapt_to_supplier_id_seq'::regclass)
product_supplier_info.supplier_id product_supplier_info_supplier_id_fkey
purchase_order.supplier_id purchase_order_supplier_id_fkey
receiving_order.supplier_id receiving_order_supplier_id_fkey
id person_adapt_to_transporter bigserial 19  √  nextval('person_adapt_to_transporter_id_seq'::regclass)
purchase_order.transporter_id purchase_order_transporter_id_fkey
receiving_order.transporter_id receiving_order_transporter_id_fkey
sale.transporter_id sale_transporter_id_fkey
id person_adapt_to_user bigserial 19  √  nextval('person_adapt_to_user_id_seq'::regclass)
calls.attendant_id calls_attendant_id_fkey
loan.responsible_id loan_responsible_id_fkey
payment_comment.author_id payment_comment_author_id_fkey
payment_renegotiation.responsible_id payment_renegotiation_responsible_id_fkey
purchase_order.responsible_id purchase_order_responsible_id_fkey
receiving_order.responsible_id receiving_order_responsible_id_fkey
stock_decrease.responsible_id stock_decrease_responsible_id_fkey
transaction_entry.user_id transaction_entry_user_id_fkey
id product bigserial 19  √  nextval('product_id_seq'::regclass)
inventory_item.product_id inventory_item_product_id_fkey
product_adapt_to_storable.original_id product_adapt_to_storable_original_id_fkey
product_component.component_id product_component_component_id_fkey
product_component.product_id product_component_product_id_fkey
product_supplier_info.product_id product_supplier_info_product_id_fkey
production_item.product_id production_item_product_id_fkey
production_material.product_id production_material_product_id_fkey
id product_adapt_to_storable bigserial 19  √  nextval('product_adapt_to_storable_id_seq'::regclass)
product_stock_item.storable_id product_stock_item_storable_id_fkey
id product_component bigserial 19  √  nextval('product_component_id_seq'::regclass)
id product_history bigserial 19  √  nextval('product_history_id_seq'::regclass)
id product_icms_template bigserial 19  √  nextval('product_icms_template_id_seq'::regclass)
product.icms_template_id product_icms_template_id_fkey
id product_ipi_template bigserial 19  √  nextval('product_ipi_template_id_seq'::regclass)
product.ipi_template_id product_ipi_template_id_fkey
id product_stock_item bigserial 19  √  nextval('product_stock_item_id_seq'::regclass)
id product_supplier_info bigserial 19  √  nextval('product_supplier_info_id_seq'::regclass)
id product_tax_template bigserial 19  √  nextval('product_tax_template_id_seq'::regclass)
product_icms_template.product_tax_template_id product_icms_template_product_tax_template_id_fkey
product_ipi_template.product_tax_template_id product_ipi_template_product_tax_template_id_fkey
id production_item bigserial 19  √  nextval('production_item_id_seq'::regclass)
id production_material bigserial 19  √  nextval('production_material_id_seq'::regclass)
id production_order bigserial 19  √  nextval('production_order_id_seq'::regclass)
production_item.order_id production_item_order_id_fkey
production_material.order_id production_material_order_id_fkey
production_service.order_id production_service_order_id_fkey
id production_service bigserial 19  √  nextval('production_service_id_seq'::regclass)
id profile_settings bigserial 19  √  nextval('profile_settings_id_seq'::regclass)
id purchase_item bigserial 19  √  nextval('purchase_item_id_seq'::regclass)
receiving_order_item.purchase_item_id receiving_order_item_purchase_item_id_fkey
id purchase_order bigserial 19  √  nextval('purchase_order_id_seq'::regclass)
purchase_item.order_id purchase_item_order_id_fkey
quotation.purchase_id quotation_purchase_id_fkey
receiving_order.purchase_id receiving_order_purchase_id_fkey
id quotation bigserial 19  √  nextval('quotation_id_seq'::regclass)
id quote_group bigserial 19  √  nextval('quote_group_id_seq'::regclass)
quotation.group_id quotation_group_id_fkey
id receiving_order bigserial 19  √  nextval('receiving_order_id_seq'::regclass)
receiving_order_item.receiving_order_id receiving_order_item_receiving_order_id_fkey
id receiving_order_item bigserial 19  √  nextval('receiving_order_item_id_seq'::regclass)
id renegotiation_data bigserial 19  √  nextval('renegotiation_data_id_seq'::regclass)
id sale bigserial 19  √  nextval('sale_id_seq'::regclass)
commission.sale_id commission_sale_id_fkey
fiscal_sale_history.sale_id fiscal_sale_history_sale_id_fkey
renegotiation_data.new_order_id renegotiation_data_new_order_id_fkey
renegotiation_data.sale_id renegotiation_data_sale_id_fkey
sale_item.sale_id sale_item_sale_id_fkey
id sale_item bigserial 19  √  nextval('sale_item_id_seq'::regclass)
sale_item_adapt_to_delivery.original_id sale_item_adapt_to_delivery_original_id_fkey
id sale_item_adapt_to_delivery bigserial 19  √  nextval('sale_item_adapt_to_delivery_id_seq'::regclass)
delivery_item.delivery_id delivery_item_delivery_id_fkey
id sale_item_icms bigserial 19  √  nextval('sale_item_icms_id_seq'::regclass)
sale_item.icms_info_id sale_item_icms_info_id_fkey
id sale_item_ipi bigserial 19  √  nextval('sale_item_ipi_id_seq'::regclass)
sale_item.ipi_info_id sale_item_ipi_info_id_fkey
id sellable bigserial 19  √  nextval('sellable_id_seq'::regclass)
commission_source.sellable_id commission_source_sellable_id_fkey
delivery_item.sellable_id delivery_item_sellable_id_fkey
loan_item.sellable_id loan_item_sellable_id_fkey
product.sellable_id product_sellable_id_fkey
product_history.sellable_id product_history_sellable_id_fkey
purchase_item.sellable_id purchase_item_sellable_id_fkey
receiving_order_item.sellable_id receiving_order_item_sellable_id_fkey
sale_item.sellable_id sale_item_sellable_id_fkey
service.sellable_id service_sellable_id_fkey
stock_decrease_item.sellable_id stock_decrease_item_sellable_id_fkey
transfer_order_item.sellable_id transfer_order_item_sellable_id_fkey
id sellable_category bigserial 19  √  nextval('sellable_category_id_seq'::regclass)
commission_source.category_id commission_source_category_id_fkey
sellable.category_id sellable_category_id_fkey
sellable_category.category_id sellable_category_category_id_fkey
id sellable_tax_constant bigserial 19  √  nextval('sellable_tax_constant_id_seq'::regclass)
sellable.tax_constant_id sellable_tax_constant_id_fkey
sellable_category.tax_constant_id sellable_category_tax_constant_id_fkey
id sellable_unit bigserial 19  √  nextval('sellable_unit_id_seq'::regclass)
sellable.unit_id sellable_unit_id_fkey
id service bigserial 19  √  nextval('service_id_seq'::regclass)
production_service.service_id production_service_service_id_fkey
id stock_decrease bigserial 19  √  nextval('stock_decrease_id_seq'::regclass)
stock_decrease_item.stock_decrease_id stock_decrease_item_stock_decrease_id_fkey
id stock_decrease_item bigserial 19  √  nextval('stock_decrease_item_id_seq'::regclass)
id system_table bigserial 19  √  nextval('system_table_id_seq'::regclass)
id till bigserial 19  √  nextval('till_id_seq'::regclass)
payment.till_id payment_till_id_fkey
till_entry.till_id till_entry_till_id_fkey
id till_entry bigserial 19  √  nextval('till_entry_id_seq'::regclass)
id transaction_entry bigserial 19  √  nextval('transaction_entry_id_seq'::regclass)
account.te_created_id account_te_created_id_fkey
account.te_modified_id account_te_modified_id_fkey
account_transaction.te_created_id account_transaction_te_created_id_fkey
account_transaction.te_modified_id account_transaction_te_modified_id_fkey
address.te_created_id address_te_created_id_fkey
address.te_modified_id address_te_modified_id_fkey
bank.te_created_id bank_te_created_id_fkey
bank.te_modified_id bank_te_modified_id_fkey
bank_account.te_created_id bank_account_te_created_id_fkey
bank_account.te_modified_id bank_account_te_modified_id_fkey
base_sellable_info.te_created_id base_sellable_info_te_created_id_fkey
base_sellable_info.te_modified_id base_sellable_info_te_modified_id_fkey
branch_station.te_created_id branch_station_te_created_id_fkey
branch_station.te_modified_id branch_station_te_modified_id_fkey
calls.te_created_id calls_te_created_id_fkey
calls.te_modified_id calls_te_modified_id_fkey
card_installment_settings.te_created_id card_installment_settings_te_created_id_fkey
card_installment_settings.te_modified_id card_installment_settings_te_modified_id_fkey
cfop_data.te_created_id cfop_data_te_created_id_fkey
cfop_data.te_modified_id cfop_data_te_modified_id_fkey
check_data.te_created_id check_data_te_created_id_fkey
check_data.te_modified_id check_data_te_modified_id_fkey
city_location.te_created_id city_location_te_created_id_fkey
city_location.te_modified_id city_location_te_modified_id_fkey
client_category.te_created_id client_category_te_created_id_fkey
client_category.te_modified_id client_category_te_modified_id_fkey
commission.te_created_id commission_te_created_id_fkey
commission.te_modified_id commission_te_modified_id_fkey
commission_source.te_created_id commission_source_te_created_id_fkey
commission_source.te_modified_id commission_source_te_modified_id_fkey
credit_card_data.te_created_id credit_card_data_te_created_id_fkey
credit_card_data.te_modified_id credit_card_data_te_modified_id_fkey
delivery_item.te_created_id delivery_item_te_created_id_fkey
delivery_item.te_modified_id delivery_item_te_modified_id_fkey
device_constant.te_created_id device_constant_te_created_id_fkey
device_constant.te_modified_id device_constant_te_modified_id_fkey
device_settings.te_created_id device_settings_te_created_id_fkey
device_settings.te_modified_id device_settings_te_modified_id_fkey
employee_role.te_created_id employee_role_te_created_id_fkey
employee_role.te_modified_id employee_role_te_modified_id_fkey
employee_role_history.te_created_id employee_role_history_te_created_id_fkey
employee_role_history.te_modified_id employee_role_history_te_modified_id_fkey
fiscal_book_entry.te_created_id fiscal_book_entry_te_created_id_fkey
fiscal_book_entry.te_modified_id fiscal_book_entry_te_modified_id_fkey
fiscal_day_history.te_created_id fiscal_day_history_te_created_id_fkey
fiscal_day_history.te_modified_id fiscal_day_history_te_modified_id_fkey
fiscal_day_tax.te_created_id fiscal_day_tax_te_created_id_fkey
fiscal_day_tax.te_modified_id fiscal_day_tax_te_modified_id_fkey
fiscal_sale_history.te_created_id fiscal_sale_history_te_created_id_fkey
fiscal_sale_history.te_modified_id fiscal_sale_history_te_modified_id_fkey
installed_plugin.te_created_id installed_plugin_te_created_id_fkey
installed_plugin.te_modified_id installed_plugin_te_modified_id_fkey
inventory.te_created_id inventory_te_created_id_fkey
inventory.te_modified_id inventory_te_modified_id_fkey
inventory_item.te_created_id inventory_item_te_created_id_fkey
inventory_item.te_modified_id inventory_item_te_modified_id_fkey
invoice_field.te_created_id invoice_field_te_created_id_fkey
invoice_field.te_modified_id invoice_field_te_modified_id_fkey
invoice_layout.te_created_id invoice_layout_te_created_id_fkey
invoice_layout.te_modified_id invoice_layout_te_modified_id_fkey
invoice_printer.te_created_id invoice_printer_te_created_id_fkey
invoice_printer.te_modified_id invoice_printer_te_modified_id_fkey
liaison.te_created_id liaison_te_created_id_fkey
liaison.te_modified_id liaison_te_modified_id_fkey
loan.te_created_id loan_te_created_id_fkey
loan.te_modified_id loan_te_modified_id_fkey
loan_item.te_created_id loan_item_te_created_id_fkey
loan_item.te_modified_id loan_item_te_modified_id_fkey
military_data.te_created_id military_data_te_created_id_fkey
military_data.te_modified_id military_data_te_modified_id_fkey
on_sale_info.te_created_id on_sale_info_te_created_id_fkey
on_sale_info.te_modified_id on_sale_info_te_modified_id_fkey
parameter_data.te_created_id parameter_data_te_created_id_fkey
parameter_data.te_modified_id parameter_data_te_modified_id_fkey
payment.te_created_id payment_te_created_id_fkey
payment.te_modified_id payment_te_modified_id_fkey
payment_adapt_to_in_payment.te_created_id payment_adapt_to_in_payment_te_created_id_fkey
payment_adapt_to_in_payment.te_modified_id payment_adapt_to_in_payment_te_modified_id_fkey
payment_adapt_to_out_payment.te_created_id payment_adapt_to_out_payment_te_created_id_fkey
payment_adapt_to_out_payment.te_modified_id payment_adapt_to_out_payment_te_modified_id_fkey
payment_category.te_created_id payment_category_te_created_id_fkey
payment_category.te_modified_id payment_category_te_modified_id_fkey
payment_change_history.te_created_id payment_change_history_te_created_id_fkey
payment_change_history.te_modified_id payment_change_history_te_modified_id_fkey
payment_comment.te_created_id payment_comment_te_created_id_fkey
payment_comment.te_modified_id payment_comment_te_modified_id_fkey
payment_flow_history.te_created_id payment_flow_history_te_created_id_fkey
payment_flow_history.te_modified_id payment_flow_history_te_modified_id_fkey
payment_group.te_created_id payment_group_te_created_id_fkey
payment_group.te_modified_id payment_group_te_modified_id_fkey
payment_method.te_created_id payment_method_te_created_id_fkey
payment_method.te_modified_id payment_method_te_modified_id_fkey
payment_renegotiation.te_created_id payment_renegotiation_te_created_id_fkey
payment_renegotiation.te_modified_id payment_renegotiation_te_modified_id_fkey
person.te_created_id person_te_created_id_fkey
person.te_modified_id person_te_modified_id_fkey
person_adapt_to_bank_branch.te_created_id person_adapt_to_bank_branch_te_created_id_fkey
person_adapt_to_bank_branch.te_modified_id person_adapt_to_bank_branch_te_modified_id_fkey
person_adapt_to_branch.te_created_id person_adapt_to_branch_te_created_id_fkey
person_adapt_to_branch.te_modified_id person_adapt_to_branch_te_modified_id_fkey
person_adapt_to_client.te_created_id person_adapt_to_client_te_created_id_fkey
person_adapt_to_client.te_modified_id person_adapt_to_client_te_modified_id_fkey
person_adapt_to_company.te_created_id person_adapt_to_company_te_created_id_fkey
person_adapt_to_company.te_modified_id person_adapt_to_company_te_modified_id_fkey
person_adapt_to_credit_provider.te_created_id person_adapt_to_credit_provider_te_created_id_fkey
person_adapt_to_credit_provider.te_modified_id person_adapt_to_credit_provider_te_modified_id_fkey
person_adapt_to_employee.te_created_id person_adapt_to_employee_te_created_id_fkey
person_adapt_to_employee.te_modified_id person_adapt_to_employee_te_modified_id_fkey
person_adapt_to_individual.te_created_id person_adapt_to_individual_te_created_id_fkey
person_adapt_to_individual.te_modified_id person_adapt_to_individual_te_modified_id_fkey
person_adapt_to_sales_person.te_created_id person_adapt_to_sales_person_te_created_id_fkey
person_adapt_to_sales_person.te_modified_id person_adapt_to_sales_person_te_modified_id_fkey
person_adapt_to_supplier.te_created_id person_adapt_to_supplier_te_created_id_fkey
person_adapt_to_supplier.te_modified_id person_adapt_to_supplier_te_modified_id_fkey
person_adapt_to_transporter.te_created_id person_adapt_to_transporter_te_created_id_fkey
person_adapt_to_transporter.te_modified_id person_adapt_to_transporter_te_modified_id_fkey
person_adapt_to_user.te_created_id person_adapt_to_user_te_created_id_fkey
person_adapt_to_user.te_modified_id person_adapt_to_user_te_modified_id_fkey
product.te_created_id product_te_created_id_fkey
product.te_modified_id product_te_modified_id_fkey
product_adapt_to_storable.te_created_id product_adapt_to_storable_te_created_id_fkey
product_adapt_to_storable.te_modified_id product_adapt_to_storable_te_modified_id_fkey
product_component.te_created_id product_component_te_created_id_fkey
product_component.te_modified_id product_component_te_modified_id_fkey
product_history.te_created_id product_history_te_created_id_fkey
product_history.te_modified_id product_history_te_modified_id_fkey
product_icms_template.te_created_id product_icms_template_te_created_id_fkey
product_icms_template.te_modified_id product_icms_template_te_modified_id_fkey
product_ipi_template.te_created_id product_ipi_template_te_created_id_fkey
product_ipi_template.te_modified_id product_ipi_template_te_modified_id_fkey
product_stock_item.te_created_id product_stock_item_te_created_id_fkey
product_stock_item.te_modified_id product_stock_item_te_modified_id_fkey
product_supplier_info.te_created_id product_supplier_info_te_created_id_fkey
product_supplier_info.te_modified_id product_supplier_info_te_modified_id_fkey
product_tax_template.te_created_id product_tax_template_te_created_id_fkey
product_tax_template.te_modified_id product_tax_template_te_modified_id_fkey
production_item.te_created_id production_item_te_created_id_fkey
production_item.te_modified_id production_item_te_modified_id_fkey
production_material.te_created_id production_material_te_created_id_fkey
production_material.te_modified_id production_material_te_modified_id_fkey
production_order.te_created_id production_order_te_created_id_fkey
production_order.te_modified_id production_order_te_modified_id_fkey
production_service.te_created_id production_service_te_created_id_fkey
production_service.te_modified_id production_service_te_modified_id_fkey
profile_settings.te_created_id profile_settings_te_created_id_fkey
profile_settings.te_modified_id profile_settings_te_modified_id_fkey
purchase_item.te_created_id purchase_item_te_created_id_fkey
purchase_item.te_modified_id purchase_item_te_modified_id_fkey
purchase_order.te_created_id purchase_order_te_created_id_fkey
purchase_order.te_modified_id purchase_order_te_modified_id_fkey
quotation.te_created_id quotation_te_created_id_fkey
quotation.te_modified_id quotation_te_modified_id_fkey
quote_group.te_created_id quote_group_te_created_id_fkey
quote_group.te_modified_id quote_group_te_modified_id_fkey
receiving_order.te_created_id receiving_order_te_created_id_fkey
receiving_order.te_modified_id receiving_order_te_modified_id_fkey
receiving_order_item.te_created_id receiving_order_item_te_created_id_fkey
receiving_order_item.te_modified_id receiving_order_item_te_modified_id_fkey
renegotiation_data.te_created_id renegotiation_data_te_created_id_fkey
renegotiation_data.te_modified_id renegotiation_data_te_modified_id_fkey
sale.te_created_id sale_te_created_id_fkey
sale.te_modified_id sale_te_modified_id_fkey
sale_item.te_created_id sale_item_te_created_id_fkey
sale_item.te_modified_id sale_item_te_modified_id_fkey
sale_item_adapt_to_delivery.te_created_id sale_item_adapt_to_delivery_te_created_id_fkey
sale_item_adapt_to_delivery.te_modified_id sale_item_adapt_to_delivery_te_modified_id_fkey
sale_item_icms.te_created_id sale_item_icms_te_created_id_fkey
sale_item_icms.te_modified_id sale_item_icms_te_modified_id_fkey
sale_item_ipi.te_created_id sale_item_ipi_te_created_id_fkey
sale_item_ipi.te_modified_id sale_item_ipi_te_modified_id_fkey
sellable.te_created_id sellable_te_created_id_fkey
sellable.te_modified_id sellable_te_modified_id_fkey
sellable_category.te_created_id sellable_category_te_created_id_fkey
sellable_category.te_modified_id sellable_category_te_modified_id_fkey
sellable_tax_constant.te_created_id sellable_tax_constant_te_created_id_fkey
sellable_tax_constant.te_modified_id sellable_tax_constant_te_modified_id_fkey
sellable_unit.te_created_id sellable_unit_te_created_id_fkey
sellable_unit.te_modified_id sellable_unit_te_modified_id_fkey
service.te_created_id service_te_created_id_fkey
service.te_modified_id service_te_modified_id_fkey
stock_decrease.te_created_id stock_decrease_te_created_id_fkey
stock_decrease.te_modified_id stock_decrease_te_modified_id_fkey
stock_decrease_item.te_created_id stock_decrease_item_te_created_id_fkey
stock_decrease_item.te_modified_id stock_decrease_item_te_modified_id_fkey
till.te_created_id till_te_created_id_fkey
till.te_modified_id till_te_modified_id_fkey
till_entry.te_created_id till_entry_te_created_id_fkey
till_entry.te_modified_id till_entry_te_modified_id_fkey
transfer_order.te_created_id transfer_order_te_created_id_fkey
transfer_order.te_modified_id transfer_order_te_modified_id_fkey
transfer_order_item.te_created_id transfer_order_item_te_created_id_fkey
transfer_order_item.te_modified_id transfer_order_item_te_modified_id_fkey
user_profile.te_created_id user_profile_te_created_id_fkey
user_profile.te_modified_id user_profile_te_modified_id_fkey
voter_data.te_created_id voter_data_te_created_id_fkey
voter_data.te_modified_id voter_data_te_modified_id_fkey
work_permit_data.te_created_id work_permit_data_te_created_id_fkey
work_permit_data.te_modified_id work_permit_data_te_modified_id_fkey
id transfer_order bigserial 19  √  nextval('transfer_order_id_seq'::regclass)
transfer_order_item.transfer_order_id transfer_order_item_transfer_order_id_fkey
id transfer_order_item bigserial 19  √  nextval('transfer_order_item_id_seq'::regclass)
id user_profile bigserial 19  √  nextval('user_profile_id_seq'::regclass)
person_adapt_to_user.profile_id person_adapt_to_user_profile_id_fkey
profile_settings.user_profile_id profile_settings_user_profile_id_fkey
id voter_data bigserial 19  √  nextval('voter_data_id_seq'::regclass)
person_adapt_to_employee.voter_data_id person_adapt_to_employee_voter_data_id_fkey
id work_permit_data bigserial 19  √  nextval('work_permit_data_id_seq'::regclass)
person_adapt_to_employee.workpermit_data_id person_adapt_to_employee_workpermit_data_id_fkey
installment_settings_id card_installments_provider_details int8 19  √  null
card_installment_settings.id card_installments_provider_details_installment_settings_id_fkey
installment_settings_id card_installments_store_details int8 19  √  null
card_installment_settings.id card_installments_store_details_installment_settings_id_fkey
installment_settings_id credit_card_details int8 19  √  null
card_installment_settings.id credit_card_details_installment_settings_id_fkey
inventory_id inventory_item int8 19
inventory.id inventory_item_inventory_id_fkey
ipi_info_id sale_item int8 19  √  null
sale_item_ipi.id sale_item_ipi_info_id_fkey
ipi_template_id product int8 19  √  null
product_ipi_template.id product_ipi_template_id_fkey
layout_id invoice_field int8 19  √  null
invoice_layout.id invoice_field_layout_id_fkey
layout_id invoice_printer int8 19  √  null
invoice_layout.id invoice_printer_layout_id_fkey
loan_id loan_item int8 19  √  null
loan.id loan_item_loan_id_fkey
manager_id person_adapt_to_branch int8 19  √  null
person_adapt_to_employee.id person_adapt_to_branch_manager_id_fkey
method_id payment int8 19  √  null
payment_method.id payment_method_id_fkey
military_data_id person_adapt_to_employee int8 19  √  null
military_data.id person_adapt_to_employee_military_data_id_fkey
new_order_id renegotiation_data int8 19  √  null
sale.id renegotiation_data_new_order_id_fkey
on_sale_info_id sellable int8 19  √  null
on_sale_info.id sellable_on_sale_info_id_fkey
order_id production_item int8 19  √  null
production_order.id production_item_order_id_fkey
order_id production_material int8 19  √  null
production_order.id production_material_order_id_fkey
order_id production_service int8 19  √  null
production_order.id production_service_order_id_fkey
order_id purchase_item int8 19  √  null
purchase_order.id purchase_item_order_id_fkey
original_id payment_adapt_to_in_payment int8 19  √  null
payment.id payment_adapt_to_in_payment_original_id_fkey
original_id payment_adapt_to_out_payment int8 19  √  null
payment.id payment_adapt_to_out_payment_original_id_fkey
original_id person_adapt_to_bank_branch int8 19  √  null
person.id person_adapt_to_bank_branch_original_id_fkey
original_id person_adapt_to_branch int8 19  √  null
person.id person_adapt_to_branch_original_id_fkey
original_id person_adapt_to_client int8 19  √  null
person.id person_adapt_to_client_original_id_fkey
original_id person_adapt_to_company int8 19  √  null
person.id person_adapt_to_company_original_id_fkey
original_id person_adapt_to_credit_provider int8 19  √  null
person.id person_adapt_to_credit_provider_original_id_fkey
original_id person_adapt_to_employee int8 19  √  null
person.id person_adapt_to_employee_original_id_fkey
original_id person_adapt_to_individual int8 19  √  null
person.id person_adapt_to_individual_original_id_fkey
original_id person_adapt_to_sales_person int8 19  √  null
person.id person_adapt_to_sales_person_original_id_fkey
original_id person_adapt_to_supplier int8 19  √  null
person.id person_adapt_to_supplier_original_id_fkey
original_id person_adapt_to_transporter int8 19  √  null
person.id person_adapt_to_transporter_original_id_fkey
original_id person_adapt_to_user int8 19  √  null
person.id person_adapt_to_user_original_id_fkey
original_id product_adapt_to_storable int8 19  √  null
product.id product_adapt_to_storable_original_id_fkey
original_id sale_item_adapt_to_delivery int8 19  √  null
sale_item.id sale_item_adapt_to_delivery_original_id_fkey
parent_id account int8 19  √  null
account.id account_parent_id_fkey
payer_id payment_group int8 19  √  null
person.id payment_group_payer_id_fkey
payment_group_id fiscal_book_entry int8 19  √  null
payment_group.id fiscal_book_entry_payment_group_id_fkey
payment_id account_transaction int8 19  √  null
payment.id account_transaction_payment_id_fkey
payment_id check_data int8 19  √  null
payment.id check_data_payment_id_fkey
payment_id commission int8 19
payment.id commission_payment_id_fkey
payment_id credit_card_data int8 19  √  null
payment.id credit_card_data_payment_id_fkey
payment_id payment_change_history int8 19  √  null
payment.id payment_change_history_payment_id_fkey
payment_id payment_comment int8 19  √  null
payment.id payment_comment_payment_id_fkey
person_id address int8 19  √  null
person.id address_person_id_fkey
person_id calls int8 19  √  null
person.id calls_person_id_fkey
person_id liaison int8 19  √  null
person.id liaison_person_id_fkey
product_id inventory_item int8 19
product.id inventory_item_product_id_fkey
product_id product_component int8 19  √  null
product.id product_component_product_id_fkey
product_id product_supplier_info int8 19
product.id product_supplier_info_product_id_fkey
product_id production_item int8 19  √  null
product.id production_item_product_id_fkey
product_id production_material int8 19  √  null
product.id production_material_product_id_fkey
product_tax_template_id product_icms_template int8 19  √  null
product_tax_template.id product_icms_template_product_tax_template_id_fkey
product_tax_template_id product_ipi_template int8 19  √  null
product_tax_template.id product_ipi_template_product_tax_template_id_fkey
profile_id person_adapt_to_user int8 19  √  null
user_profile.id person_adapt_to_user_profile_id_fkey
provider_id credit_card_data int8 19  √  null
person_adapt_to_credit_provider.id credit_card_data_provider_id_fkey
purchase_id quotation int8 19  √  null
purchase_order.id quotation_purchase_id_fkey
purchase_id receiving_order int8 19
purchase_order.id receiving_order_purchase_id_fkey
purchase_item_id receiving_order_item int8 19  √  null
purchase_item.id receiving_order_item_purchase_item_id_fkey
receiving_order_id receiving_order_item int8 19  √  null
receiving_order.id receiving_order_item_receiving_order_id_fkey
recipient_id payment_group int8 19  √  null
person.id payment_group_recipient_id_fkey
removed_by_id stock_decrease int8 19  √  null
person_adapt_to_employee.id stock_decrease_removed_by_id_fkey
renegotiation_id payment_group int8 19  √  null
payment_renegotiation.id payment_group_renegotiation_id_fkey
responsible_id loan int8 19  √  null
person_adapt_to_user.id loan_responsible_id_fkey
responsible_id payment_renegotiation int8 19  √  null
person_adapt_to_user.id payment_renegotiation_responsible_id_fkey
responsible_id production_order int8 19  √  null
person_adapt_to_employee.id production_order_responsible_id_fkey
responsible_id purchase_order int8 19  √  null
person_adapt_to_user.id purchase_order_responsible_id_fkey
responsible_id receiving_order int8 19  √  null
person_adapt_to_user.id receiving_order_responsible_id_fkey
responsible_id renegotiation_data int8 19  √  null
person.id renegotiation_data_responsible_id_fkey
responsible_id stock_decrease int8 19  √  null
person_adapt_to_user.id stock_decrease_responsible_id_fkey
role_id employee_role_history int8 19  √  null
employee_role.id employee_role_history_role_id_fkey
role_id person_adapt_to_employee int8 19  √  null
employee_role.id person_adapt_to_employee_role_id_fkey
sale_id commission int8 19
sale.id commission_sale_id_fkey
sale_id fiscal_sale_history int8 19  √  null
sale.id fiscal_sale_history_sale_id_fkey
sale_id renegotiation_data int8 19  √  null
sale.id renegotiation_data_sale_id_fkey
sale_id sale_item int8 19  √  null
sale.id sale_item_sale_id_fkey
salesperson_id commission int8 19
person_adapt_to_sales_person.id commission_salesperson_id_fkey
salesperson_id sale int8 19  √  null
person_adapt_to_sales_person.id sale_salesperson_id_fkey
sellable_id commission_source int8 19  √  null
sellable.id commission_source_sellable_id_fkey
sellable_id delivery_item int8 19  √  null
sellable.id delivery_item_sellable_id_fkey
sellable_id loan_item int8 19  √  null
sellable.id loan_item_sellable_id_fkey
sellable_id product int8 19  √  null
sellable.id product_sellable_id_fkey
sellable_id product_history int8 19  √  null
sellable.id product_history_sellable_id_fkey
sellable_id purchase_item int8 19  √  null
sellable.id purchase_item_sellable_id_fkey
sellable_id receiving_order_item int8 19  √  null
sellable.id receiving_order_item_sellable_id_fkey
sellable_id sale_item int8 19  √  null
sellable.id sale_item_sellable_id_fkey
sellable_id service int8 19  √  null
sellable.id service_sellable_id_fkey
sellable_id stock_decrease_item int8 19  √  null
sellable.id stock_decrease_item_sellable_id_fkey
sellable_id transfer_order_item int8 19
sellable.id transfer_order_item_sellable_id_fkey
service_id production_service int8 19  √  null
service.id production_service_service_id_fkey
source_account_id account_transaction int8 19
account.id account_transaction_source_account_id_fkey
source_branch_id transfer_order int8 19
person_adapt_to_branch.id transfer_order_source_branch_id_fkey
source_responsible_id transfer_order int8 19
person_adapt_to_employee.id transfer_order_source_responsible_id_fkey
station_id account int8 19  √  null
branch_station.id account_station_id_fkey
station_id device_settings int8 19  √  null
branch_station.id device_settings_station_id_fkey
station_id fiscal_day_history int8 19  √  null
branch_station.id fiscal_day_history_station_id_fkey
station_id invoice_printer int8 19  √  null
branch_station.id invoice_printer_station_id_fkey
station_id till int8 19  √  null
branch_station.id till_station_id_fkey
stock_decrease_id stock_decrease_item int8 19  √  null
stock_decrease.id stock_decrease_item_stock_decrease_id_fkey
storable_id product_stock_item int8 19  √  null
product_adapt_to_storable.id product_stock_item_storable_id_fkey
supplier_id product_supplier_info int8 19
person_adapt_to_supplier.id product_supplier_info_supplier_id_fkey
supplier_id purchase_order int8 19  √  null
person_adapt_to_supplier.id purchase_order_supplier_id_fkey
supplier_id receiving_order int8 19  √  null
person_adapt_to_supplier.id receiving_order_supplier_id_fkey
tax_constant_id sellable int8 19  √  null
sellable_tax_constant.id sellable_tax_constant_id_fkey
tax_constant_id sellable_category int8 19  √  null
sellable_tax_constant.id sellable_category_tax_constant_id_fkey
te_created_id account int8 19  √  null
transaction_entry.id account_te_created_id_fkey
te_created_id account_transaction int8 19  √  null
transaction_entry.id account_transaction_te_created_id_fkey
te_created_id address int8 19  √  null
transaction_entry.id address_te_created_id_fkey
te_created_id bank int8 19  √  null
transaction_entry.id bank_te_created_id_fkey
te_created_id bank_account int8 19  √  null
transaction_entry.id bank_account_te_created_id_fkey
te_created_id base_sellable_info int8 19  √  null
transaction_entry.id base_sellable_info_te_created_id_fkey
te_created_id branch_station int8 19  √  null
transaction_entry.id branch_station_te_created_id_fkey
te_created_id calls int8 19  √  null
transaction_entry.id calls_te_created_id_fkey
te_created_id card_installment_settings int8 19  √  null
transaction_entry.id card_installment_settings_te_created_id_fkey
te_created_id cfop_data int8 19  √  null
transaction_entry.id cfop_data_te_created_id_fkey
te_created_id check_data int8 19  √  null
transaction_entry.id check_data_te_created_id_fkey
te_created_id city_location int8 19  √  null
transaction_entry.id city_location_te_created_id_fkey
te_created_id client_category int8 19  √  null
transaction_entry.id client_category_te_created_id_fkey
te_created_id commission int8 19  √  null
transaction_entry.id commission_te_created_id_fkey
te_created_id commission_source int8 19  √  null
transaction_entry.id commission_source_te_created_id_fkey
te_created_id credit_card_data int8 19  √  null
transaction_entry.id credit_card_data_te_created_id_fkey
te_created_id delivery_item int8 19  √  null
transaction_entry.id delivery_item_te_created_id_fkey
te_created_id device_constant int8 19  √  null
transaction_entry.id device_constant_te_created_id_fkey
te_created_id device_settings int8 19  √  null
transaction_entry.id device_settings_te_created_id_fkey
te_created_id employee_role int8 19  √  null
transaction_entry.id employee_role_te_created_id_fkey
te_created_id employee_role_history int8 19  √  null
transaction_entry.id employee_role_history_te_created_id_fkey
te_created_id fiscal_book_entry int8 19  √  null
transaction_entry.id fiscal_book_entry_te_created_id_fkey
te_created_id fiscal_day_history int8 19  √  null
transaction_entry.id fiscal_day_history_te_created_id_fkey
te_created_id fiscal_day_tax int8 19  √  null
transaction_entry.id fiscal_day_tax_te_created_id_fkey
te_created_id fiscal_sale_history int8 19  √  null
transaction_entry.id fiscal_sale_history_te_created_id_fkey
te_created_id installed_plugin int8 19  √  null
transaction_entry.id installed_plugin_te_created_id_fkey
te_created_id inventory int8 19  √  null
transaction_entry.id inventory_te_created_id_fkey
te_created_id inventory_item int8 19  √  null
transaction_entry.id inventory_item_te_created_id_fkey
te_created_id invoice_field int8 19  √  null
transaction_entry.id invoice_field_te_created_id_fkey
te_created_id invoice_layout int8 19  √  null
transaction_entry.id invoice_layout_te_created_id_fkey
te_created_id invoice_printer int8 19  √  null
transaction_entry.id invoice_printer_te_created_id_fkey
te_created_id liaison int8 19  √  null
transaction_entry.id liaison_te_created_id_fkey
te_created_id loan int8 19  √  null
transaction_entry.id loan_te_created_id_fkey
te_created_id loan_item int8 19  √  null
transaction_entry.id loan_item_te_created_id_fkey
te_created_id military_data int8 19  √  null
transaction_entry.id military_data_te_created_id_fkey
te_created_id on_sale_info int8 19  √  null
transaction_entry.id on_sale_info_te_created_id_fkey
te_created_id parameter_data int8 19  √  null
transaction_entry.id parameter_data_te_created_id_fkey
te_created_id payment int8 19  √  null
transaction_entry.id payment_te_created_id_fkey
te_created_id payment_adapt_to_in_payment int8 19  √  null
transaction_entry.id payment_adapt_to_in_payment_te_created_id_fkey
te_created_id payment_adapt_to_out_payment int8 19  √  null
transaction_entry.id payment_adapt_to_out_payment_te_created_id_fkey
te_created_id payment_category int8 19  √  null
transaction_entry.id payment_category_te_created_id_fkey
te_created_id payment_change_history int8 19  √  null
transaction_entry.id payment_change_history_te_created_id_fkey
te_created_id payment_comment int8 19  √  null
transaction_entry.id payment_comment_te_created_id_fkey
te_created_id payment_flow_history int8 19  √  null
transaction_entry.id payment_flow_history_te_created_id_fkey
te_created_id payment_group int8 19  √  null
transaction_entry.id payment_group_te_created_id_fkey
te_created_id payment_method int8 19  √  null
transaction_entry.id payment_method_te_created_id_fkey
te_created_id payment_renegotiation int8 19  √  null
transaction_entry.id payment_renegotiation_te_created_id_fkey
te_created_id person int8 19  √  null
transaction_entry.id person_te_created_id_fkey
te_created_id person_adapt_to_bank_branch int8 19  √  null
transaction_entry.id person_adapt_to_bank_branch_te_created_id_fkey
te_created_id person_adapt_to_branch int8 19  √  null
transaction_entry.id person_adapt_to_branch_te_created_id_fkey
te_created_id person_adapt_to_client int8 19  √  null
transaction_entry.id person_adapt_to_client_te_created_id_fkey
te_created_id person_adapt_to_company int8 19  √  null
transaction_entry.id person_adapt_to_company_te_created_id_fkey
te_created_id person_adapt_to_credit_provider int8 19  √  null
transaction_entry.id person_adapt_to_credit_provider_te_created_id_fkey
te_created_id person_adapt_to_employee int8 19  √  null
transaction_entry.id person_adapt_to_employee_te_created_id_fkey
te_created_id person_adapt_to_individual int8 19  √  null
transaction_entry.id person_adapt_to_individual_te_created_id_fkey
te_created_id person_adapt_to_sales_person int8 19  √  null
transaction_entry.id person_adapt_to_sales_person_te_created_id_fkey
te_created_id person_adapt_to_supplier int8 19  √  null
transaction_entry.id person_adapt_to_supplier_te_created_id_fkey
te_created_id person_adapt_to_transporter int8 19  √  null
transaction_entry.id person_adapt_to_transporter_te_created_id_fkey
te_created_id person_adapt_to_user int8 19  √  null
transaction_entry.id person_adapt_to_user_te_created_id_fkey
te_created_id product int8 19  √  null
transaction_entry.id product_te_created_id_fkey
te_created_id product_adapt_to_storable int8 19  √  null
transaction_entry.id product_adapt_to_storable_te_created_id_fkey
te_created_id product_component int8 19  √  null
transaction_entry.id product_component_te_created_id_fkey
te_created_id product_history int8 19  √  null
transaction_entry.id product_history_te_created_id_fkey
te_created_id product_icms_template int8 19  √  null
transaction_entry.id product_icms_template_te_created_id_fkey
te_created_id product_ipi_template int8 19  √  null
transaction_entry.id product_ipi_template_te_created_id_fkey
te_created_id product_stock_item int8 19  √  null
transaction_entry.id product_stock_item_te_created_id_fkey
te_created_id product_supplier_info int8 19  √  null
transaction_entry.id product_supplier_info_te_created_id_fkey
te_created_id product_tax_template int8 19  √  null
transaction_entry.id product_tax_template_te_created_id_fkey
te_created_id production_item int8 19  √  null
transaction_entry.id production_item_te_created_id_fkey
te_created_id production_material int8 19  √  null
transaction_entry.id production_material_te_created_id_fkey
te_created_id production_order int8 19  √  null
transaction_entry.id production_order_te_created_id_fkey
te_created_id production_service int8 19  √  null
transaction_entry.id production_service_te_created_id_fkey
te_created_id profile_settings int8 19  √  null
transaction_entry.id profile_settings_te_created_id_fkey
te_created_id purchase_item int8 19  √  null
transaction_entry.id purchase_item_te_created_id_fkey
te_created_id purchase_order int8 19  √  null
transaction_entry.id purchase_order_te_created_id_fkey
te_created_id quotation int8 19  √  null
transaction_entry.id quotation_te_created_id_fkey
te_created_id quote_group int8 19  √  null
transaction_entry.id quote_group_te_created_id_fkey
te_created_id receiving_order int8 19  √  null
transaction_entry.id receiving_order_te_created_id_fkey
te_created_id receiving_order_item int8 19  √  null
transaction_entry.id receiving_order_item_te_created_id_fkey
te_created_id renegotiation_data int8 19  √  null
transaction_entry.id renegotiation_data_te_created_id_fkey
te_created_id sale int8 19  √  null
transaction_entry.id sale_te_created_id_fkey
te_created_id sale_item int8 19  √  null
transaction_entry.id sale_item_te_created_id_fkey
te_created_id sale_item_adapt_to_delivery int8 19  √  null
transaction_entry.id sale_item_adapt_to_delivery_te_created_id_fkey
te_created_id sale_item_icms int8 19  √  null
transaction_entry.id sale_item_icms_te_created_id_fkey
te_created_id sale_item_ipi int8 19  √  null
transaction_entry.id sale_item_ipi_te_created_id_fkey
te_created_id sellable int8 19  √  null
transaction_entry.id sellable_te_created_id_fkey
te_created_id sellable_category int8 19  √  null
transaction_entry.id sellable_category_te_created_id_fkey
te_created_id sellable_tax_constant int8 19  √  null
transaction_entry.id sellable_tax_constant_te_created_id_fkey
te_created_id sellable_unit int8 19  √  null
transaction_entry.id sellable_unit_te_created_id_fkey
te_created_id service int8 19  √  null
transaction_entry.id service_te_created_id_fkey
te_created_id stock_decrease int8 19  √  null
transaction_entry.id stock_decrease_te_created_id_fkey
te_created_id stock_decrease_item int8 19  √  null
transaction_entry.id stock_decrease_item_te_created_id_fkey
te_created_id till int8 19  √  null
transaction_entry.id till_te_created_id_fkey
te_created_id till_entry int8 19  √  null
transaction_entry.id till_entry_te_created_id_fkey
te_created_id transfer_order int8 19  √  null
transaction_entry.id transfer_order_te_created_id_fkey
te_created_id transfer_order_item int8 19  √  null
transaction_entry.id transfer_order_item_te_created_id_fkey
te_created_id user_profile int8 19  √  null
transaction_entry.id user_profile_te_created_id_fkey
te_created_id voter_data int8 19  √  null
transaction_entry.id voter_data_te_created_id_fkey
te_created_id work_permit_data int8 19  √  null
transaction_entry.id work_permit_data_te_created_id_fkey
te_modified_id account int8 19  √  null
transaction_entry.id account_te_modified_id_fkey
te_modified_id account_transaction int8 19  √  null
transaction_entry.id account_transaction_te_modified_id_fkey
te_modified_id address int8 19  √  null
transaction_entry.id address_te_modified_id_fkey
te_modified_id bank int8 19  √  null
transaction_entry.id bank_te_modified_id_fkey
te_modified_id bank_account int8 19  √  null
transaction_entry.id bank_account_te_modified_id_fkey
te_modified_id base_sellable_info int8 19  √  null
transaction_entry.id base_sellable_info_te_modified_id_fkey
te_modified_id branch_station int8 19  √  null
transaction_entry.id branch_station_te_modified_id_fkey
te_modified_id calls int8 19  √  null
transaction_entry.id calls_te_modified_id_fkey
te_modified_id card_installment_settings int8 19  √  null
transaction_entry.id card_installment_settings_te_modified_id_fkey
te_modified_id cfop_data int8 19  √  null
transaction_entry.id cfop_data_te_modified_id_fkey
te_modified_id check_data int8 19  √  null
transaction_entry.id check_data_te_modified_id_fkey
te_modified_id city_location int8 19  √  null
transaction_entry.id city_location_te_modified_id_fkey
te_modified_id client_category int8 19  √  null
transaction_entry.id client_category_te_modified_id_fkey
te_modified_id commission int8 19  √  null
transaction_entry.id commission_te_modified_id_fkey
te_modified_id commission_source int8 19  √  null
transaction_entry.id commission_source_te_modified_id_fkey
te_modified_id credit_card_data int8 19  √  null
transaction_entry.id credit_card_data_te_modified_id_fkey
te_modified_id delivery_item int8 19  √  null
transaction_entry.id delivery_item_te_modified_id_fkey
te_modified_id device_constant int8 19  √  null
transaction_entry.id device_constant_te_modified_id_fkey
te_modified_id device_settings int8 19  √  null
transaction_entry.id device_settings_te_modified_id_fkey
te_modified_id employee_role int8 19  √  null
transaction_entry.id employee_role_te_modified_id_fkey
te_modified_id employee_role_history int8 19  √  null
transaction_entry.id employee_role_history_te_modified_id_fkey
te_modified_id fiscal_book_entry int8 19  √  null
transaction_entry.id fiscal_book_entry_te_modified_id_fkey
te_modified_id fiscal_day_history int8 19  √  null
transaction_entry.id fiscal_day_history_te_modified_id_fkey
te_modified_id fiscal_day_tax int8 19  √  null
transaction_entry.id fiscal_day_tax_te_modified_id_fkey
te_modified_id fiscal_sale_history int8 19  √  null
transaction_entry.id fiscal_sale_history_te_modified_id_fkey
te_modified_id installed_plugin int8 19  √  null
transaction_entry.id installed_plugin_te_modified_id_fkey
te_modified_id inventory int8 19  √  null
transaction_entry.id inventory_te_modified_id_fkey
te_modified_id inventory_item int8 19  √  null
transaction_entry.id inventory_item_te_modified_id_fkey
te_modified_id invoice_field int8 19  √  null
transaction_entry.id invoice_field_te_modified_id_fkey
te_modified_id invoice_layout int8 19  √  null
transaction_entry.id invoice_layout_te_modified_id_fkey
te_modified_id invoice_printer int8 19  √  null
transaction_entry.id invoice_printer_te_modified_id_fkey
te_modified_id liaison int8 19  √  null
transaction_entry.id liaison_te_modified_id_fkey
te_modified_id loan int8 19  √  null
transaction_entry.id loan_te_modified_id_fkey
te_modified_id loan_item int8 19  √  null
transaction_entry.id loan_item_te_modified_id_fkey
te_modified_id military_data int8 19  √  null
transaction_entry.id military_data_te_modified_id_fkey
te_modified_id on_sale_info int8 19  √  null
transaction_entry.id on_sale_info_te_modified_id_fkey
te_modified_id parameter_data int8 19  √  null
transaction_entry.id parameter_data_te_modified_id_fkey
te_modified_id payment int8 19  √  null
transaction_entry.id payment_te_modified_id_fkey
te_modified_id payment_adapt_to_in_payment int8 19  √  null
transaction_entry.id payment_adapt_to_in_payment_te_modified_id_fkey
te_modified_id payment_adapt_to_out_payment int8 19  √  null
transaction_entry.id payment_adapt_to_out_payment_te_modified_id_fkey
te_modified_id payment_category int8 19  √  null
transaction_entry.id payment_category_te_modified_id_fkey
te_modified_id payment_change_history int8 19  √  null
transaction_entry.id payment_change_history_te_modified_id_fkey
te_modified_id payment_comment int8 19  √  null
transaction_entry.id payment_comment_te_modified_id_fkey
te_modified_id payment_flow_history int8 19  √  null
transaction_entry.id payment_flow_history_te_modified_id_fkey
te_modified_id payment_group int8 19  √  null
transaction_entry.id payment_group_te_modified_id_fkey
te_modified_id payment_method int8 19  √  null
transaction_entry.id payment_method_te_modified_id_fkey
te_modified_id payment_renegotiation int8 19  √  null
transaction_entry.id payment_renegotiation_te_modified_id_fkey
te_modified_id person int8 19  √  null
transaction_entry.id person_te_modified_id_fkey
te_modified_id person_adapt_to_bank_branch int8 19  √  null
transaction_entry.id person_adapt_to_bank_branch_te_modified_id_fkey
te_modified_id person_adapt_to_branch int8 19  √  null
transaction_entry.id person_adapt_to_branch_te_modified_id_fkey
te_modified_id person_adapt_to_client int8 19  √  null
transaction_entry.id person_adapt_to_client_te_modified_id_fkey
te_modified_id person_adapt_to_company int8 19  √  null
transaction_entry.id person_adapt_to_company_te_modified_id_fkey
te_modified_id person_adapt_to_credit_provider int8 19  √  null
transaction_entry.id person_adapt_to_credit_provider_te_modified_id_fkey
te_modified_id person_adapt_to_employee int8 19  √  null
transaction_entry.id person_adapt_to_employee_te_modified_id_fkey
te_modified_id person_adapt_to_individual int8 19  √  null
transaction_entry.id person_adapt_to_individual_te_modified_id_fkey
te_modified_id person_adapt_to_sales_person int8 19  √  null
transaction_entry.id person_adapt_to_sales_person_te_modified_id_fkey
te_modified_id person_adapt_to_supplier int8 19  √  null
transaction_entry.id person_adapt_to_supplier_te_modified_id_fkey
te_modified_id person_adapt_to_transporter int8 19  √  null
transaction_entry.id person_adapt_to_transporter_te_modified_id_fkey
te_modified_id person_adapt_to_user int8 19  √  null
transaction_entry.id person_adapt_to_user_te_modified_id_fkey
te_modified_id product int8 19  √  null
transaction_entry.id product_te_modified_id_fkey
te_modified_id product_adapt_to_storable int8 19  √  null
transaction_entry.id product_adapt_to_storable_te_modified_id_fkey
te_modified_id product_component int8 19  √  null
transaction_entry.id product_component_te_modified_id_fkey
te_modified_id product_history int8 19  √  null
transaction_entry.id product_history_te_modified_id_fkey
te_modified_id product_icms_template int8 19  √  null
transaction_entry.id product_icms_template_te_modified_id_fkey
te_modified_id product_ipi_template int8 19  √  null
transaction_entry.id product_ipi_template_te_modified_id_fkey
te_modified_id product_stock_item int8 19  √  null
transaction_entry.id product_stock_item_te_modified_id_fkey
te_modified_id product_supplier_info int8 19  √  null
transaction_entry.id product_supplier_info_te_modified_id_fkey
te_modified_id product_tax_template int8 19  √  null
transaction_entry.id product_tax_template_te_modified_id_fkey
te_modified_id production_item int8 19  √  null
transaction_entry.id production_item_te_modified_id_fkey
te_modified_id production_material int8 19  √  null
transaction_entry.id production_material_te_modified_id_fkey
te_modified_id production_order int8 19  √  null
transaction_entry.id production_order_te_modified_id_fkey
te_modified_id production_service int8 19  √  null
transaction_entry.id production_service_te_modified_id_fkey
te_modified_id profile_settings int8 19  √  null
transaction_entry.id profile_settings_te_modified_id_fkey
te_modified_id purchase_item int8 19  √  null
transaction_entry.id purchase_item_te_modified_id_fkey
te_modified_id purchase_order int8 19  √  null
transaction_entry.id purchase_order_te_modified_id_fkey
te_modified_id quotation int8 19  √  null
transaction_entry.id quotation_te_modified_id_fkey
te_modified_id quote_group int8 19  √  null
transaction_entry.id quote_group_te_modified_id_fkey
te_modified_id receiving_order int8 19  √  null
transaction_entry.id receiving_order_te_modified_id_fkey
te_modified_id receiving_order_item int8 19  √  null
transaction_entry.id receiving_order_item_te_modified_id_fkey
te_modified_id renegotiation_data int8 19  √  null
transaction_entry.id renegotiation_data_te_modified_id_fkey
te_modified_id sale int8 19  √  null
transaction_entry.id sale_te_modified_id_fkey
te_modified_id sale_item int8 19  √  null
transaction_entry.id sale_item_te_modified_id_fkey
te_modified_id sale_item_adapt_to_delivery int8 19  √  null
transaction_entry.id sale_item_adapt_to_delivery_te_modified_id_fkey
te_modified_id sale_item_icms int8 19  √  null
transaction_entry.id sale_item_icms_te_modified_id_fkey
te_modified_id sale_item_ipi int8 19  √  null
transaction_entry.id sale_item_ipi_te_modified_id_fkey
te_modified_id sellable int8 19  √  null
transaction_entry.id sellable_te_modified_id_fkey
te_modified_id sellable_category int8 19  √  null
transaction_entry.id sellable_category_te_modified_id_fkey
te_modified_id sellable_tax_constant int8 19  √  null
transaction_entry.id sellable_tax_constant_te_modified_id_fkey
te_modified_id sellable_unit int8 19  √  null
transaction_entry.id sellable_unit_te_modified_id_fkey
te_modified_id service int8 19  √  null
transaction_entry.id service_te_modified_id_fkey
te_modified_id stock_decrease int8 19  √  null
transaction_entry.id stock_decrease_te_modified_id_fkey
te_modified_id stock_decrease_item int8 19  √  null
transaction_entry.id stock_decrease_item_te_modified_id_fkey
te_modified_id till int8 19  √  null
transaction_entry.id till_te_modified_id_fkey
te_modified_id till_entry int8 19  √  null
transaction_entry.id till_entry_te_modified_id_fkey
te_modified_id transfer_order int8 19  √  null
transaction_entry.id transfer_order_te_modified_id_fkey
te_modified_id transfer_order_item int8 19  √  null
transaction_entry.id transfer_order_item_te_modified_id_fkey
te_modified_id user_profile int8 19  √  null
transaction_entry.id user_profile_te_modified_id_fkey
te_modified_id voter_data int8 19  √  null
transaction_entry.id voter_data_te_modified_id_fkey
te_modified_id work_permit_data int8 19  √  null
transaction_entry.id work_permit_data_te_modified_id_fkey
till_id payment int8 19  √  null
till.id payment_till_id_fkey
till_id till_entry int8 19
till.id till_entry_till_id_fkey
transfer_order_id transfer_order_item int8 19
transfer_order.id transfer_order_item_transfer_order_id_fkey
transporter_id purchase_order int8 19  √  null
person_adapt_to_transporter.id purchase_order_transporter_id_fkey
transporter_id receiving_order int8 19  √  null
person_adapt_to_transporter.id receiving_order_transporter_id_fkey
transporter_id sale int8 19  √  null
person_adapt_to_transporter.id sale_transporter_id_fkey
unit_id sellable int8 19  √  null
sellable_unit.id sellable_unit_id_fkey
user_profile_id profile_settings int8 19  √  null
user_profile.id profile_settings_user_profile_id_fkey
voter_data_id person_adapt_to_employee int8 19  √  null
voter_data.id person_adapt_to_employee_voter_data_id_fkey
width invoice_field int8 19
width invoice_layout int8 19
workpermit_data_id person_adapt_to_employee int8 19  √  null
work_permit_data.id person_adapt_to_employee_workpermit_data_id_fkey
x invoice_field int8 19
y invoice_field int8 19
admission_date person_adapt_to_employee timestamp 29,6  √  null
began employee_role_history timestamp 29,6  √  null
birth_date person_adapt_to_individual timestamp 29,6  √  null
cancel_date payment timestamp 29,6  √  null
cancel_date sale timestamp 29,6  √  null
change_date payment_change_history timestamp 29,6  √  null
close_date inventory timestamp 29,6  √  null
close_date loan timestamp 29,6  √  null
close_date payment_renegotiation timestamp 29,6  √  null
close_date production_order timestamp 29,6  √  null
close_date sale timestamp 29,6  √  null
closing_date till timestamp 29,6  √  null
completion_date sale_item timestamp 29,6  √  null
confirm_date purchase_order timestamp 29,6  √  null
confirm_date receiving_order timestamp 29,6  √  null
confirm_date sale timestamp 29,6  √  null
confirm_date stock_decrease timestamp 29,6  √  null
date account_transaction timestamp 29,6
date calls timestamp 29,6  √  null
date fiscal_book_entry timestamp 29,6  √  null
date payment_comment timestamp 29,6  √  null
date till_entry timestamp 29,6  √  null
decreased_date product_history timestamp 29,6  √  null
due_date payment timestamp 29,6  √  null
ended employee_role_history timestamp 29,6  √  null
estimated_fix_date sale_item timestamp 29,6  √  null
expected_pay_date purchase_order timestamp 29,6  √  null
expected_receival_date purchase_item timestamp 29,6  √  null
expected_receival_date purchase_order timestamp 29,6  √  null
expected_start_date production_order timestamp 29,6  √  null
expire_date loan timestamp 29,6  √  null
expire_date sale timestamp 29,6  √  null
expire_vacation person_adapt_to_employee timestamp 29,6  √  null
history_date payment_flow_history timestamp 29,6  √  null
last_due_date payment_change_history timestamp 29,6  √  null
new_due_date payment_change_history timestamp 29,6  √  null
on_sale_end_date on_sale_info timestamp 29,6  √  null
on_sale_start_date on_sale_info timestamp 29,6  √  null
open_contract_date person_adapt_to_credit_provider timestamp 29,6  √  null
open_contract_date person_adapt_to_transporter timestamp 29,6  √  null
open_date inventory timestamp 29,6
open_date loan timestamp 29,6  √  null
open_date payment timestamp 29,6  √  null
open_date payment_renegotiation timestamp 29,6  √  null
open_date production_order timestamp 29,6  √  null
open_date purchase_order timestamp 29,6  √  null
open_date sale timestamp 29,6  √  null
open_date transfer_order timestamp 29,6
opening_date till timestamp 29,6  √  null
p_cred_sn_valid_until product_icms_template timestamp 29,6  √  null
paid_date payment timestamp 29,6  √  null
pis_registry_date work_permit_data timestamp 29,6  √  null
production_date product_history timestamp 29,6  √  null
quote_deadline purchase_order timestamp 29,6  √  null
receival_date purchase_order timestamp 29,6  √  null
receival_date receiving_order timestamp 29,6  √  null
receival_date transfer_order timestamp 29,6  √  null
received_date product_history timestamp 29,6  √  null
reduction_date fiscal_day_history timestamp 29,6  √  null
return_date sale timestamp 29,6  √  null
rg_expedition_date person_adapt_to_individual timestamp 29,6  √  null
sold_date product_history timestamp 29,6  √  null
start_date production_order timestamp 29,6  √  null
sync_time branch_synchronization timestamp 29,6
te_time transaction_entry timestamp 29,6
updated system_table timestamp 29,6  √  null
account bank_account text 2147483647  √  null
address sale_item_adapt_to_delivery text 2147483647  √  null
app_dir_name profile_settings text 2147483647  √  null
barcode sellable text 2147483647  √  null
branch bank_account text 2147483647  √  null
brand device_settings text 2147483647  √  null
c_enq product_ipi_template text 2147483647  √  null
c_enq sale_item_ipi text 2147483647  √  null
c_selo product_ipi_template text 2147483647  √  null
c_selo sale_item_ipi text 2147483647  √  null
category military_data text 2147483647  √  null
change_reason payment_change_history text 2147483647  √  null
city city_location text 2147483647  √  null
city_registry person_adapt_to_company text 2147483647  √  null
cl_enq product_ipi_template text 2147483647  √  null
cl_enq sale_item_ipi text 2147483647  √  null
cnpj person_adapt_to_company text 2147483647  √  null
cnpj_prod product_ipi_template text 2147483647  √  null
cnpj_prod sale_item_ipi text 2147483647  √  null
code account text 2147483647  √  null
code account_transaction text 2147483647  √  null
code cfop_data text 2147483647  √  null
code fiscal_day_tax text 2147483647  √  null
code sellable text 2147483647  √  null
color payment_category text 2147483647  √  null
comment payment_comment text 2147483647  √  null
compensation_code bank text 2147483647  √  null
complement address text 2147483647  √  null
constant_name device_constant text 2147483647  √  null
country city_location text 2147483647  √  null
cpf person_adapt_to_individual text 2147483647  √  null
description account text 2147483647
description account_transaction text 2147483647  √  null
description base_sellable_info text 2147483647  √  null
description cfop_data text 2147483647  √  null
description invoice_layout varchar 2147483647
description invoice_printer varchar 2147483647
description payment text 2147483647  √  null
description payment_method text 2147483647  √  null
description production_order text 2147483647  √  null
description sellable_category text 2147483647  √  null
description sellable_tax_constant text 2147483647  √  null
description sellable_unit text 2147483647  √  null
description till_entry text 2147483647  √  null
device_name invoice_printer varchar 2147483647
device_value device_constant bytea 2147483647  √  null
district address text 2147483647  √  null
document fiscal_sale_history text 2147483647  √  null
education_level person_adapt_to_employee text 2147483647  √  null
email person text 2147483647  √  null
ex_tipi product text 2147483647  √  null
fancy_name person_adapt_to_company text 2147483647  √  null
father_name person_adapt_to_individual text 2147483647  √  null
fax_number person text 2147483647  √  null
field_name invoice_field varchar 2147483647
field_name parameter_data text 2147483647
field_value parameter_data text 2147483647  √  null
full_image product bytea 2147483647  √  null
genero product text 2147483647  √  null
image product bytea 2147483647  √  null
image service bytea 2147483647  √  null
location product text 2147483647  √  null
manufacturer product text 2147483647  √  null
message calls text 2147483647  √  null
method_name payment_method text 2147483647  √  null
mobile_number person text 2147483647  √  null
model device_settings text 2147483647  √  null
mother_name person_adapt_to_individual text 2147483647  √  null
name bank text 2147483647  √  null
name branch_station text 2147483647  √  null
name client_category text 2147483647  √  null
name employee_role text 2147483647
name liaison text 2147483647  √  null
name payment_category text 2147483647  √  null
name person text 2147483647  √  null
name product_tax_template text 2147483647  √  null
name user_profile text 2147483647  √  null
ncm product text 2147483647  √  null
notes loan text 2147483647  √  null
notes payment_renegotiation text 2147483647  √  null
notes person text 2147483647  √  null
notes product_supplier_info text 2147483647  √  null
notes purchase_order text 2147483647  √  null
notes receiving_order text 2147483647  √  null
notes sale text 2147483647  √  null
notes sale_item text 2147483647  √  null
notes sellable text 2147483647  √  null
notes stock_decrease text 2147483647  √  null
number military_data text 2147483647  √  null
number voter_data text 2147483647  √  null
number work_permit_data text 2147483647  √  null
occupation person_adapt_to_individual text 2147483647  √  null
operation_nature sale text 2147483647  √  null
part_number product text 2147483647  √  null
password person_adapt_to_user text 2147483647  √  null
payment_number payment text 2147483647  √  null
phone_number liaison text 2147483647  √  null
phone_number person text 2147483647  √  null
pis_bank work_permit_data text 2147483647  √  null
pis_number work_permit_data text 2147483647  √  null
plugin_name installed_plugin text 2147483647
policy branch_synchronization text 2147483647
postal_code address text 2147483647  √  null
product_desc person_adapt_to_supplier text 2147483647  √  null
provider_id person_adapt_to_credit_provider text 2147483647  √  null
reason inventory_item text 2147483647  √  null
reason renegotiation_data text 2147483647  √  null
reason stock_decrease text 2147483647  √  null
registry_number person_adapt_to_employee text 2147483647  √  null
removed_by loan text 2147483647  √  null
rg_expedition_local person_adapt_to_individual text 2147483647  √  null
rg_number person_adapt_to_individual text 2147483647  √  null
salesperson_name purchase_order text 2147483647  √  null
section voter_data text 2147483647  √  null
serial fiscal_day_history text 2147483647  √  null
series_number military_data text 2147483647  √  null
series_number work_permit_data text 2147483647  √  null
short_name bank text 2147483647  √  null
short_name person_adapt_to_credit_provider text 2147483647  √  null
spouse_name person_adapt_to_individual text 2147483647  √  null
state city_location text 2147483647  √  null
state_registry person_adapt_to_company text 2147483647  √  null
street address text 2147483647  √  null
type fiscal_day_tax text 2147483647  √  null
username person_adapt_to_user text 2147483647
zone voter_data text 2147483647  √  null