SchemaSpy Analysis of george.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Jul 14 15:21 GMT-03:00 2009
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
george.public contains 739 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
city_location_id address int8 19  √  null
city_location.id address_city_location_id_fkey
complement address text 2147483647  √  null
district address text 2147483647  √  null
id address bigserial 19  √  nextval('address_id_seq'::regclass)
is_main_address address bool 1  √  null
person_id address int8 19  √  null
person.id address_person_id_fkey
postal_code address text 2147483647  √  null
street address text 2147483647  √  null
streetnumber address int4 10  √  null
te_created_id address int8 19  √  null
transaction_entry.id address_te_created_id_fkey
te_modified_id address int8 19  √  null
transaction_entry.id address_te_modified_id_fkey
compensation_code bank text 2147483647  √  null
id bank bigserial 19  √  nextval('bank_id_seq'::regclass)
person_adapt_to_bank_branch.bank_id person_adapt_to_bank_branch_bank_id_fkey
name bank text 2147483647  √  null
short_name bank text 2147483647  √  null
te_created_id bank int8 19  √  null
transaction_entry.id bank_te_created_id_fkey
te_modified_id bank int8 19  √  null
transaction_entry.id bank_te_modified_id_fkey
account bank_account text 2147483647  √  null
bank_id bank_account int4 10  √  null
branch bank_account text 2147483647  √  null
id bank_account bigserial 19  √  nextval('bank_account_id_seq'::regclass)
check_data.bank_data_id check_data_bank_data_id_fkey
payment_destination.account_id payment_destination_account_id_fkey
person_adapt_to_employee.bank_account_id person_adapt_to_employee_bank_account_id_fkey
te_created_id bank_account int8 19  √  null
transaction_entry.id bank_account_te_created_id_fkey
te_modified_id bank_account int8 19  √  null
transaction_entry.id bank_account_te_modified_id_fkey
commission base_sellable_info numeric 10,2  √  null
description base_sellable_info text 2147483647  √  null
id base_sellable_info bigserial 19  √  nextval('base_sellable_info_id_seq'::regclass)
sellable.base_sellable_info_id sellable_base_sellable_info_id_fkey
max_discount base_sellable_info numeric 10,2  √  null
price base_sellable_info numeric 10,2  √  null
te_created_id base_sellable_info int8 19  √  null
transaction_entry.id base_sellable_info_te_created_id_fkey
te_modified_id base_sellable_info int8 19  √  null
transaction_entry.id base_sellable_info_te_modified_id_fkey
branch_id branch_station int8 19  √  null
person_adapt_to_branch.id branch_station_branch_id_fkey
id branch_station bigserial 19  √  nextval('branch_station_id_seq'::regclass)
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
is_active branch_station bool 1  √  null
name branch_station text 2147483647  √  null
te_created_id branch_station int8 19  √  null
transaction_entry.id branch_station_te_created_id_fkey
te_modified_id branch_station int8 19  √  null
transaction_entry.id branch_station_te_modified_id_fkey
branch_id branch_synchronization int8 19  √  null
person_adapt_to_branch.id branch_synchronization_branch_id_fkey
id branch_synchronization bigserial 19  √  nextval('branch_synchronization_id_seq'::regclass)
policy branch_synchronization text 2147483647
sync_time branch_synchronization timestamp 29,6
attendant_id calls int8 19  √  null
person_adapt_to_user.id calls_attendant_id_fkey
date calls timestamp 29,6  √  null
id calls bigserial 19  √  nextval('calls_id_seq'::regclass)
message calls text 2147483647  √  null
person_id calls int8 19  √  null
person.id calls_person_id_fkey
te_created_id calls int8 19  √  null
transaction_entry.id calls_te_created_id_fkey
te_modified_id calls int8 19  √  null
transaction_entry.id calls_te_modified_id_fkey
closing_day card_installment_settings int4 10  √  null
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
payment_day card_installment_settings int4 10  √  null
te_created_id card_installment_settings int8 19  √  null
transaction_entry.id card_installment_settings_te_created_id_fkey
te_modified_id card_installment_settings int8 19  √  null
transaction_entry.id card_installment_settings_te_modified_id_fkey
id card_installments_provider_details bigserial 19  √  nextval('card_installments_provider_details_id_seq'::regclass)
installment_settings_id card_installments_provider_details int8 19  √  null
card_installment_settings.id card_installments_provider_details_installment_settings_id_fkey
max_installments_number card_installments_provider_details int4 10  √  null
id card_installments_store_details bigserial 19  √  nextval('card_installments_store_details_id_seq'::regclass)
installment_settings_id card_installments_store_details int8 19  √  null
card_installment_settings.id card_installments_store_details_installment_settings_id_fkey
max_installments_number card_installments_store_details int4 10  √  null
code cfop_data text 2147483647  √  null
description cfop_data text 2147483647  √  null
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
product_retention_history.cfop_id product_retention_history_cfop_id_fkey
receiving_order.cfop_id receiving_order_cfop_id_fkey
sale.cfop_id sale_cfop_id_fkey
te_created_id cfop_data int8 19  √  null
transaction_entry.id cfop_data_te_created_id_fkey
te_modified_id cfop_data int8 19  √  null
transaction_entry.id cfop_data_te_modified_id_fkey
bank_data_id check_data int8 19  √  null
bank_account.id check_data_bank_data_id_fkey
id check_data bigserial 19  √  nextval('check_data_id_seq'::regclass)
payment_id check_data int8 19  √  null
payment.id check_data_payment_id_fkey
te_created_id check_data int8 19  √  null
transaction_entry.id check_data_te_created_id_fkey
te_modified_id check_data int8 19  √  null
transaction_entry.id check_data_te_modified_id_fkey
city city_location text 2147483647  √  null
country city_location text 2147483647  √  null
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
state city_location text 2147483647  √  null
te_created_id city_location int8 19  √  null
transaction_entry.id city_location_te_created_id_fkey
te_modified_id city_location int8 19  √  null
transaction_entry.id city_location_te_modified_id_fkey
commission_type commission int4 10
id commission bigserial 19  √  nextval('commission_id_seq'::regclass)
payment_id commission int8 19
payment.id commission_payment_id_fkey
sale_id commission int8 19
sale.id commission_sale_id_fkey
salesperson_id commission int8 19
person_adapt_to_sales_person.id commission_salesperson_id_fkey
te_created_id commission int8 19  √  null
transaction_entry.id commission_te_created_id_fkey
te_modified_id commission int8 19  √  null
transaction_entry.id commission_te_modified_id_fkey
value commission numeric 10,2
category_id commission_source int8 19  √  null
sellable_category.id commission_source_category_id_fkey
direct_value commission_source numeric 10,2
id commission_source bigserial 19  √  nextval('commission_source_id_seq'::regclass)
installments_value commission_source numeric 10,2
sellable_id commission_source int8 19  √  null
sellable.id commission_source_asellable_id_fkey
te_created_id commission_source int8 19  √  null
transaction_entry.id commission_source_te_created_id_fkey
te_modified_id commission_source int8 19  √  null
transaction_entry.id commission_source_te_modified_id_fkey
card_type credit_card_data int4 10  √  null
id credit_card_data bigserial 19  √  nextval('credit_card_data_id_seq'::regclass)
payment_id credit_card_data int8 19  √  null
payment.id credit_card_data_payment_id_fkey
provider_id credit_card_data int8 19  √  null
person_adapt_to_credit_provider.id credit_card_data_provider_id_fkey
te_created_id credit_card_data int8 19  √  null
transaction_entry.id credit_card_data_te_created_id_fkey
te_modified_id credit_card_data int8 19  √  null
transaction_entry.id credit_card_data_te_modified_id_fkey
id credit_card_details bigserial 19  √  nextval('credit_card_details_id_seq'::regclass)
installment_settings_id credit_card_details int8 19  √  null
card_installment_settings.id credit_card_details_installment_settings_id_fkey
group_id credit_provider_group_data int8 19  √  null
payment_group.id credit_provider_group_data_group_id_fkey
id credit_provider_group_data bigserial 19  √  nextval('credit_provider_group_data_id_seq'::regclass)
installments_number credit_provider_group_data int4 10  √  null
payment_type_id credit_provider_group_data int8 19  √  null
payment_method_details.id credit_provider_group_data_payment_type_id_fkey
provider_id credit_provider_group_data int8 19  √  null
person_adapt_to_credit_provider.id credit_provider_group_data_provider_id_fkey
te_created_id credit_provider_group_data int8 19  √  null
transaction_entry.id credit_provider_group_data_te_created_id_fkey
te_modified_id credit_provider_group_data int8 19  √  null
transaction_entry.id credit_provider_group_data_te_modified_id_fkey
id debit_card_details bigserial 19  √  nextval('debit_card_details_id_seq'::regclass)
receive_days debit_card_details int4 10  √  null
delivery_id delivery_item int8 19  √  null
sale_item_adapt_to_delivery.id delivery_item_delivery_id_fkey
id delivery_item bigserial 19  √  nextval('delivery_item_id_seq'::regclass)
quantity delivery_item numeric 10,2  √  null
sellable_id delivery_item int8 19  √  null
sellable.id delivery_item_sellable_id_fkey
te_created_id delivery_item int8 19  √  null
transaction_entry.id delivery_item_te_created_id_fkey
te_modified_id delivery_item int8 19  √  null
transaction_entry.id delivery_item_te_modified_id_fkey
constant_enum device_constant int4 10  √  null
constant_name device_constant text 2147483647  √  null
constant_type device_constant int4 10  √  null
constant_value device_constant numeric 10,2  √  null
device_settings_id device_constant int8 19  √  null
device_settings.id device_constant_device_settings_id_fkey
device_value device_constant bytea 2147483647  √  null
id device_constant bigserial 19  √  nextval('device_constant_id_seq'::regclass)
is_valid_model device_constant bool 1  √  null
te_created_id device_constant int8 19  √  null
transaction_entry.id device_constant_te_created_id_fkey
te_modified_id device_constant int8 19  √  null
transaction_entry.id device_constant_te_modified_id_fkey
brand device_settings text 2147483647  √  null
device device_settings int4 10  √  null
id device_settings bigserial 19  √  nextval('device_settings_id_seq'::regclass)
device_constant.device_settings_id device_constant_device_settings_id_fkey
is_active device_settings bool 1  √  null
model device_settings text 2147483647  √  null
station_id device_settings int8 19  √  null
branch_station.id device_settings_station_id_fkey
te_created_id device_settings int8 19  √  null
transaction_entry.id device_settings_te_created_id_fkey
te_modified_id device_settings int8 19  √  null
transaction_entry.id device_settings_te_modified_id_fkey
type device_settings int4 10  √  null
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
name employee_role text 2147483647
te_created_id employee_role int8 19  √  null
transaction_entry.id employee_role_te_created_id_fkey
te_modified_id employee_role int8 19  √  null
transaction_entry.id employee_role_te_modified_id_fkey
began employee_role_history timestamp 29,6  √  null
employee_id employee_role_history int8 19  √  null
person_adapt_to_employee.id employee_role_history_employee_id_fkey
ended employee_role_history timestamp 29,6  √  null
id employee_role_history bigserial 19  √  nextval('employee_role_history_id_seq'::regclass)
is_active employee_role_history bool 1  √  null
role_id employee_role_history int8 19  √  null
employee_role.id employee_role_history_role_id_fkey
salary employee_role_history numeric 10,2  √  null
te_created_id employee_role_history int8 19  √  null
transaction_entry.id employee_role_history_te_created_id_fkey
te_modified_id employee_role_history int8 19  √  null
transaction_entry.id employee_role_history_te_modified_id_fkey
branch_id fiscal_book_entry int8 19  √  null
person_adapt_to_branch.id fiscal_book_entry_branch_id_fkey
cfop_id fiscal_book_entry int8 19  √  null
cfop_data.id fiscal_book_entry_cfop_id_fkey
date fiscal_book_entry timestamp 29,6  √  null
drawee_id fiscal_book_entry int8 19  √  null
person.id fiscal_book_entry_drawee_id_fkey
entry_type fiscal_book_entry int4 10  √  null
icms_value fiscal_book_entry numeric 10,2  √  null
id fiscal_book_entry bigserial 19  √  nextval('fiscal_book_entry_id_seq'::regclass)
invoice_number fiscal_book_entry int4 10  √  null
ipi_value fiscal_book_entry numeric 10,2  √  null
is_reversal fiscal_book_entry bool 1  √  null
iss_value fiscal_book_entry numeric 10,2  √  null
payment_group_id fiscal_book_entry int8 19  √  null
payment_group.id fiscal_book_entry_payment_group_id_fkey
te_created_id fiscal_book_entry int8 19  √  null
transaction_entry.id fiscal_book_entry_te_created_id_fkey
te_modified_id fiscal_book_entry int8 19  √  null
transaction_entry.id fiscal_book_entry_te_modified_id_fkey
coupon_end fiscal_day_history int4 10  √  null
coupon_start fiscal_day_history int4 10  √  null
cro fiscal_day_history int4 10  √  null
crz fiscal_day_history int4 10  √  null
emission_date fiscal_day_history date 13  √  null
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
period_total fiscal_day_history numeric 10,2  √  null
reduction_date fiscal_day_history timestamp 29,6  √  null
serial fiscal_day_history text 2147483647  √  null
serial_id fiscal_day_history int4 10  √  null
station_id fiscal_day_history int8 19  √  null
branch_station.id fiscal_day_history_station_id_fkey
tax_total fiscal_day_history numeric 10,2  √  null
te_created_id fiscal_day_history int8 19  √  null
transaction_entry.id fiscal_day_history_te_created_id_fkey
te_modified_id fiscal_day_history int8 19  √  null
transaction_entry.id fiscal_day_history_te_modified_id_fkey
total fiscal_day_history numeric 10,2  √  null
code fiscal_day_tax text 2147483647  √  null
fiscal_day_history_id fiscal_day_tax int8 19  √  null
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)
te_created_id fiscal_day_tax int8 19  √  null
transaction_entry.id fiscal_day_tax_te_created_id_fkey
te_modified_id fiscal_day_tax int8 19  √  null
transaction_entry.id fiscal_day_tax_te_modified_id_fkey
type fiscal_day_tax text 2147483647  √  null
value fiscal_day_tax numeric 10,2  √  null
coo fiscal_sale_history int4 10  √  null
document fiscal_sale_history text 2147483647  √  null
document_counter fiscal_sale_history int4 10  √  null
document_type fiscal_sale_history int4 10  √  null
id fiscal_sale_history bigserial 19  √  nextval('fiscal_sale_history_id_seq'::regclass)
sale_id fiscal_sale_history int8 19  √  null
sale.id fiscal_sale_history_sale_id_fkey
te_created_id fiscal_sale_history int8 19  √  null
transaction_entry.id fiscal_sale_history_te_created_id_fkey
te_modified_id fiscal_sale_history int8 19  √  null
transaction_entry.id fiscal_sale_history_te_modified_id_fkey
id installed_plugin bigserial 19  √  nextval('installed_plugin_id_seq'::regclass)
plugin_name installed_plugin text 2147483647
plugin_version installed_plugin int4 10  √  null
te_created_id installed_plugin int8 19  √  null
transaction_entry.id installed_plugin_te_created_id_fkey
te_modified_id installed_plugin int8 19  √  null
transaction_entry.id installed_plugin_te_modified_id_fkey
branch_id inventory int8 19
person_adapt_to_branch.id inventory_branch_id_fkey
close_date inventory timestamp 29,6  √  null
id inventory bigserial 19  √  nextval('inventory_id_seq'::regclass)
inventory_item.inventory_id inventory_item_inventory_id_fkey
invoice_number inventory int4 10  √  null
open_date inventory timestamp 29,6
status inventory int4 10  √  null
te_created_id inventory int8 19  √  null
transaction_entry.id inventory_te_created_id_fkey
te_modified_id inventory int8 19  √  null
transaction_entry.id inventory_te_modified_id_fkey
actual_quantity inventory_item numeric 10,2  √  null
cfop_data_id inventory_item int8 19  √  null
cfop_data.id inventory_item_cfop_data_id_fkey
id inventory_item bigserial 19  √  nextval('inventory_item_id_seq'::regclass)
inventory_id inventory_item int8 19
inventory.id inventory_item_inventory_id_fkey
product_cost inventory_item numeric 10,4  √  null
product_id inventory_item int8 19
product.id inventory_item_product_id_fkey
reason inventory_item text 2147483647  √  null
recorded_quantity inventory_item numeric 10,2  √  null
te_created_id inventory_item int8 19  √  null
transaction_entry.id inventory_item_te_created_id_fkey
te_modified_id inventory_item int8 19  √  null
transaction_entry.id inventory_item_te_modified_id_fkey
field_name invoice_field varchar 2147483647
height invoice_field int8 19
id invoice_field bigserial 19  √  nextval('invoice_field_id_seq'::regclass)
layout_id invoice_field int8 19  √  null
invoice_layout.id invoice_field_layout_id_fkey
te_created_id invoice_field int8 19  √  null
transaction_entry.id invoice_field_te_created_id_fkey
te_modified_id invoice_field int8 19  √  null
transaction_entry.id invoice_field_te_modified_id_fkey
width invoice_field int8 19
x invoice_field int8 19
y invoice_field int8 19
description invoice_layout varchar 2147483647
height invoice_layout int8 19
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
te_created_id invoice_layout int8 19  √  null
transaction_entry.id invoice_layout_te_created_id_fkey
te_modified_id invoice_layout int8 19  √  null
transaction_entry.id invoice_layout_te_modified_id_fkey
width invoice_layout int8 19
description invoice_printer varchar 2147483647
device_name invoice_printer varchar 2147483647
id invoice_printer bigserial 19  √  nextval('invoice_printer_id_seq'::regclass)
layout_id invoice_printer int8 19  √  null
invoice_layout.id invoice_printer_layout_id_fkey
station_id invoice_printer int8 19  √  null
branch_station.id invoice_printer_station_id_fkey
te_created_id invoice_printer int8 19  √  null
transaction_entry.id invoice_printer_te_created_id_fkey
te_modified_id invoice_printer int8 19  √  null
transaction_entry.id invoice_printer_te_modified_id_fkey
id liaison bigserial 19  √  nextval('liaison_id_seq'::regclass)
name liaison text 2147483647  √  null
person_id liaison int8 19  √  null
person.id liaison_person_id_fkey
phone_number liaison text 2147483647  √  null
te_created_id liaison int8 19  √  null
transaction_entry.id liaison_te_created_id_fkey
te_modified_id liaison int8 19  √  null
transaction_entry.id liaison_te_modified_id_fkey
category military_data text 2147483647  √  null
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
number military_data text 2147483647  √  null
series_number military_data text 2147483647  √  null
te_created_id military_data int8 19  √  null
transaction_entry.id military_data_te_created_id_fkey
te_modified_id military_data int8 19  √  null
transaction_entry.id military_data_te_modified_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
on_sale_end_date on_sale_info timestamp 29,6  √  null
on_sale_price on_sale_info numeric 10,2  √  null
on_sale_start_date on_sale_info timestamp 29,6  √  null
te_created_id on_sale_info int8 19  √  null
transaction_entry.id on_sale_info_te_created_id_fkey
te_modified_id on_sale_info int8 19  √  null
transaction_entry.id on_sale_info_te_modified_id_fkey
field_name parameter_data text 2147483647
field_value parameter_data text 2147483647  √  null
id parameter_data bigserial 19  √  nextval('parameter_data_id_seq'::regclass)
is_editable parameter_data bool 1  √  null
te_created_id parameter_data int8 19  √  null
transaction_entry.id parameter_data_te_created_id_fkey
te_modified_id parameter_data int8 19  √  null
transaction_entry.id parameter_data_te_modified_id_fkey
base_value payment numeric 10,2  √  null
cancel_date payment timestamp 29,6  √  null
category_id payment int8 19  √  null
payment_category.id payment_category_id_fkey
description payment text 2147483647  √  null
destination_id payment int8 19  √  null
payment_destination.id payment_destination_id_fkey
discount payment numeric 10,2  √  null
due_date payment timestamp 29,6  √  null
group_id payment int8 19  √  null
payment_group.id payment_group_id_fkey
id payment bigserial 19  √  nextval('payment_id_seq'::regclass)
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
interest payment numeric 10,2  √  null
method_id payment int8 19  √  null
payment_method.id payment_method_id_fkey
open_date payment timestamp 29,6  √  null
paid_date payment timestamp 29,6  √  null
paid_value payment numeric 10,2  √  null
payment_number payment text 2147483647  √  null
penalty payment numeric 10,2  √  null
status payment int4 10  √  null
te_created_id payment int8 19  √  null
transaction_entry.id payment_te_created_id_fkey
te_modified_id payment int8 19  √  null
transaction_entry.id payment_te_modified_id_fkey
till_id payment int8 19  √  null
till.id payment_till_id_fkey
value payment numeric 10,2  √  null
id payment_adapt_to_in_payment bigserial 19  √  nextval('payment_adapt_to_in_payment_id_seq'::regclass)
original_id payment_adapt_to_in_payment int8 19  √  null
payment.id payment_adapt_to_in_payment_original_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_modified_id payment_adapt_to_in_payment int8 19  √  null
transaction_entry.id payment_adapt_to_in_payment_te_modified_id_fkey
id payment_adapt_to_out_payment bigserial 19  √  nextval('payment_adapt_to_out_payment_id_seq'::regclass)
original_id payment_adapt_to_out_payment int8 19  √  null
payment.id payment_adapt_to_out_payment_original_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_modified_id payment_adapt_to_out_payment int8 19  √  null
transaction_entry.id payment_adapt_to_out_payment_te_modified_id_fkey
color payment_category text 2147483647  √  null
id payment_category bigserial 19  √  nextval('payment_category_id_seq'::regclass)
payment.category_id payment_category_id_fkey
name payment_category text 2147483647  √  null
te_created_id payment_category int8 19  √  null
transaction_entry.id payment_category_te_created_id_fkey
te_modified_id payment_category int8 19  √  null
transaction_entry.id payment_category_te_modified_id_fkey
change_date payment_change_history timestamp 29,6  √  null
change_reason payment_change_history text 2147483647  √  null
id payment_change_history bigserial 19  √  nextval('payment_change_history_id_seq'::regclass)
last_due_date payment_change_history timestamp 29,6  √  null
last_status payment_change_history int4 10  √  null
new_due_date payment_change_history timestamp 29,6  √  null
new_status payment_change_history int4 10  √  null
payment_id payment_change_history int8 19  √  null
payment.id payment_change_history_payment_id_fkey
te_created_id payment_change_history int8 19  √  null
transaction_entry.id payment_change_history_te_created_id_fkey
te_modified_id payment_change_history int8 19  √  null
transaction_entry.id payment_change_history_te_modified_id_fkey
account_id payment_destination int8 19  √  null
bank_account.id payment_destination_account_id_fkey
branch_id payment_destination int8 19  √  null
person_adapt_to_branch.id payment_destination_branch_id_fkey
description payment_destination text 2147483647  √  null
id payment_destination bigserial 19  √  nextval('payment_destination_id_seq'::regclass)
payment.destination_id payment_destination_id_fkey
payment_method.destination_id payment_method_destination_id_fkey
payment_method_details.destination_id payment_method_details_destination_id_fkey
notes payment_destination text 2147483647  √  null
te_created_id payment_destination int8 19  √  null
transaction_entry.id payment_destination_te_created_id_fkey
te_modified_id payment_destination int8 19  √  null
transaction_entry.id payment_destination_te_modified_id_fkey
id payment_group bigserial 19  √  nextval('payment_group_id_seq'::regclass)
credit_provider_group_data.group_id credit_provider_group_data_group_id_fkey
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
payer_id payment_group int8 19  √  null
person.id payment_group_payer_id_fkey
recipient_id payment_group int8 19  √  null
person.id payment_group_recipient_id_fkey
renegotiation_id payment_group int8 19  √  null
payment_renegotiation.id payment_group_renegotiation_id_fkey
status payment_group int4 10  √  null
te_created_id payment_group int8 19  √  null
transaction_entry.id payment_group_te_created_id_fkey
te_modified_id payment_group int8 19  √  null
transaction_entry.id payment_group_te_modified_id_fkey
closing_day payment_method int4 10  √  null
daily_penalty payment_method numeric 10,2  √  null
description payment_method text 2147483647  √  null
destination_id payment_method int8 19  √  null
payment_destination.id payment_method_destination_id_fkey
id payment_method bigserial 19  √  nextval('payment_method_id_seq'::regclass)
payment.method_id payment_method_id_fkey
interest payment_method numeric 10,2  √  null
is_active payment_method bool 1  √  null
max_installments payment_method int4 10  √  null
method_name payment_method text 2147483647  √  null
payment_day payment_method int4 10  √  null
te_created_id payment_method int8 19  √  null
transaction_entry.id payment_method_te_created_id_fkey
te_modified_id payment_method int8 19  √  null
transaction_entry.id payment_method_te_modified_id_fkey
child_name payment_method_details varchar 255  √  null
commission payment_method_details numeric 10,2  √  null
destination_id payment_method_details int8 19  √  null
payment_destination.id payment_method_details_destination_id_fkey
id payment_method_details bigserial 19  √  nextval('payment_method_details_id_seq'::regclass)
credit_provider_group_data.payment_type_id credit_provider_group_data_payment_type_id_fkey
is_active payment_method_details bool 1  √  null
provider_id payment_method_details int8 19  √  null
person_adapt_to_credit_provider.id payment_method_details_provider_id_fkey
branch_id payment_renegotiation int8 19  √  null
person_adapt_to_branch.id payment_renegotiation_branch_id_fkey
client_id payment_renegotiation int8 19  √  null
person_adapt_to_client.id payment_renegotiation_client_id_fkey
close_date payment_renegotiation timestamp 29,6  √  null
discount_value payment_renegotiation numeric 10,2  √  null
group_id payment_renegotiation int8 19  √  null
payment_group.id payment_renegotiation_group_id_fkey
id payment_renegotiation bigserial 19  √  nextval('payment_renegotiation_id_seq'::regclass)
payment_group.renegotiation_id payment_group_renegotiation_id_fkey
notes payment_renegotiation text 2147483647  √  null
open_date payment_renegotiation timestamp 29,6  √  null
responsible_id payment_renegotiation int8 19  √  null
person_adapt_to_user.id payment_renegotiation_responsible_id_fkey
status payment_renegotiation int4 10  √  null
surcharge_value payment_renegotiation numeric 10,2  √  null
te_created_id payment_renegotiation int8 19  √  null
transaction_entry.id payment_renegotiation_te_created_id_fkey
te_modified_id payment_renegotiation int8 19  √  null
transaction_entry.id payment_renegotiation_te_modified_id_fkey
total payment_renegotiation numeric 10,2  √  null
email person text 2147483647  √  null
fax_number person text 2147483647  √  null
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
mobile_number person text 2147483647  √  null
name person text 2147483647  √  null
notes person text 2147483647  √  null
phone_number person text 2147483647  √  null
te_created_id person int8 19  √  null
transaction_entry.id person_te_created_id_fkey
te_modified_id person int8 19  √  null
transaction_entry.id person_te_modified_id_fkey
bank_id person_adapt_to_bank_branch int8 19  √  null
bank.id person_adapt_to_bank_branch_bank_id_fkey
id person_adapt_to_bank_branch bigserial 19  √  nextval('person_adapt_to_bank_branch_id_seq'::regclass)
is_active person_adapt_to_bank_branch bool 1  √  null
original_id person_adapt_to_bank_branch int8 19  √  null
person.id person_adapt_to_bank_branch_original_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_modified_id person_adapt_to_bank_branch int8 19  √  null
transaction_entry.id person_adapt_to_bank_branch_te_modified_id_fkey
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
payment_destination.branch_id payment_destination_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
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
transfer_order.destination_branch_id transfer_order_destination_branch_id_fkey
transfer_order.source_branch_id transfer_order_source_branch_id_fkey
is_active person_adapt_to_branch bool 1  √  null
manager_id person_adapt_to_branch int8 19  √  null
person_adapt_to_employee.id person_adapt_to_branch_manager_id_fkey
original_id person_adapt_to_branch int8 19  √  null
person.id person_adapt_to_branch_original_id_fkey
te_created_id person_adapt_to_branch int8 19  √  null
transaction_entry.id person_adapt_to_branch_te_created_id_fkey
te_modified_id person_adapt_to_branch int8 19  √  null
transaction_entry.id person_adapt_to_branch_te_modified_id_fkey
credit_limit person_adapt_to_client numeric 10,2  √  0
days_late person_adapt_to_client int4 10  √  null
id person_adapt_to_client bigserial 19  √  nextval('person_adapt_to_client_id_seq'::regclass)
payment_renegotiation.client_id payment_renegotiation_client_id_fkey
sale.client_id sale_client_id_fkey
original_id person_adapt_to_client int8 19  √  null
person.id person_adapt_to_client_original_id_fkey
status person_adapt_to_client int4 10  √  null
te_created_id person_adapt_to_client int8 19  √  null
transaction_entry.id person_adapt_to_client_te_created_id_fkey
te_modified_id person_adapt_to_client int8 19  √  null
transaction_entry.id person_adapt_to_client_te_modified_id_fkey
cnpj person_adapt_to_company text 2147483647  √  null
fancy_name person_adapt_to_company text 2147483647  √  null
id person_adapt_to_company bigserial 19  √  nextval('person_adapt_to_company_id_seq'::regclass)
is_active person_adapt_to_company bool 1  √  null
original_id person_adapt_to_company int8 19  √  null
person.id person_adapt_to_company_original_id_fkey
state_registry person_adapt_to_company text 2147483647  √  null
te_created_id person_adapt_to_company int8 19  √  null
transaction_entry.id person_adapt_to_company_te_created_id_fkey
te_modified_id person_adapt_to_company int8 19  √  null
transaction_entry.id person_adapt_to_company_te_modified_id_fkey
closing_day person_adapt_to_credit_provider int4 10  √  null
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
credit_provider_group_data.provider_id credit_provider_group_data_provider_id_fkey
payment_method_details.provider_id payment_method_details_provider_id_fkey
is_active person_adapt_to_credit_provider bool 1  √  null
max_installments person_adapt_to_credit_provider int4 10  √  null
open_contract_date person_adapt_to_credit_provider timestamp 29,6  √  null
original_id person_adapt_to_credit_provider int8 19  √  null
person.id person_adapt_to_credit_provider_original_id_fkey
payment_day person_adapt_to_credit_provider int4 10  √  null
provider_fee person_adapt_to_credit_provider numeric 10,4 0
provider_id person_adapt_to_credit_provider text 2147483647  √  null
provider_type person_adapt_to_credit_provider int4 10  √  null
short_name person_adapt_to_credit_provider text 2147483647  √  null
te_created_id person_adapt_to_credit_provider int8 19  √  null
transaction_entry.id person_adapt_to_credit_provider_te_created_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
admission_date person_adapt_to_employee timestamp 29,6  √  null
bank_account_id person_adapt_to_employee int8 19  √  null
bank_account.id person_adapt_to_employee_bank_account_id_fkey
dependent_person_number person_adapt_to_employee int4 10  √  null
education_level person_adapt_to_employee text 2147483647  √  null
expire_vacation person_adapt_to_employee timestamp 29,6  √  null
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
transfer_order.destination_responsible_id transfer_order_destination_responsible_id_fkey
transfer_order.source_responsible_id transfer_order_source_responsible_id_fkey
is_active person_adapt_to_employee bool 1  √  null
military_data_id person_adapt_to_employee int8 19  √  null
military_data.id person_adapt_to_employee_military_data_id_fkey
original_id person_adapt_to_employee int8 19  √  null
person.id person_adapt_to_employee_original_id_fkey
registry_number person_adapt_to_employee text 2147483647  √  null
role_id person_adapt_to_employee int8 19  √  null
employee_role.id person_adapt_to_employee_role_id_fkey
salary person_adapt_to_employee numeric 10,2  √  null
status person_adapt_to_employee int4 10  √  null
te_created_id person_adapt_to_employee int8 19  √  null
transaction_entry.id person_adapt_to_employee_te_created_id_fkey
te_modified_id person_adapt_to_employee int8 19  √  null
transaction_entry.id person_adapt_to_employee_te_modified_id_fkey
voter_data_id person_adapt_to_employee int8 19  √  null
voter_data.id person_adapt_to_employee_voter_data_id_fkey
workpermit_data_id person_adapt_to_employee int8 19  √  null
work_permit_data.id person_adapt_to_employee_workpermit_data_id_fkey
birth_date person_adapt_to_individual timestamp 29,6  √  null
birth_location_id person_adapt_to_individual int8 19  √  null
city_location.id person_adapt_to_individual_birth_location_id_fkey
cpf person_adapt_to_individual text 2147483647  √  null
father_name person_adapt_to_individual text 2147483647  √  null
gender person_adapt_to_individual int4 10  √  null
id person_adapt_to_individual bigserial 19  √  nextval('person_adapt_to_individual_id_seq'::regclass)
is_active person_adapt_to_individual bool 1  √  null
marital_status person_adapt_to_individual int4 10  √  null
mother_name person_adapt_to_individual text 2147483647  √  null
occupation person_adapt_to_individual text 2147483647  √  null
original_id person_adapt_to_individual int8 19  √  null
person.id person_adapt_to_individual_original_id_fkey
rg_expedition_date person_adapt_to_individual timestamp 29,6  √  null
rg_expedition_local person_adapt_to_individual text 2147483647  √  null
rg_number person_adapt_to_individual text 2147483647  √  null
spouse_name person_adapt_to_individual text 2147483647  √  null
te_created_id person_adapt_to_individual int8 19  √  null
transaction_entry.id person_adapt_to_individual_te_created_id_fkey
te_modified_id person_adapt_to_individual int8 19  √  null
transaction_entry.id person_adapt_to_individual_te_modified_id_fkey
comission person_adapt_to_sales_person numeric 10,2  √  null
comission_type person_adapt_to_sales_person int4 10  √  null
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
is_active person_adapt_to_sales_person bool 1  √  null
original_id person_adapt_to_sales_person int8 19  √  null
person.id person_adapt_to_sales_person_original_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_modified_id person_adapt_to_sales_person int8 19  √  null
transaction_entry.id person_adapt_to_sales_person_te_modified_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
is_active person_adapt_to_supplier bool 1  √  null
original_id person_adapt_to_supplier int8 19  √  null
person.id person_adapt_to_supplier_original_id_fkey
product_desc person_adapt_to_supplier text 2147483647  √  null
status person_adapt_to_supplier int4 10  √  null
te_created_id person_adapt_to_supplier int8 19  √  null
transaction_entry.id person_adapt_to_supplier_te_created_id_fkey
te_modified_id person_adapt_to_supplier int8 19  √  null
transaction_entry.id person_adapt_to_supplier_te_modified_id_fkey
freight_percentage person_adapt_to_transporter numeric 10,2
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
is_active person_adapt_to_transporter bool 1  √  null
open_contract_date person_adapt_to_transporter timestamp 29,6  √  null
original_id person_adapt_to_transporter int8 19  √  null
person.id person_adapt_to_transporter_original_id_fkey
te_created_id person_adapt_to_transporter int8 19  √  null
transaction_entry.id person_adapt_to_transporter_te_created_id_fkey
te_modified_id person_adapt_to_transporter int8 19  √  null
transaction_entry.id person_adapt_to_transporter_te_modified_id_fkey
id person_adapt_to_user bigserial 19  √  nextval('person_adapt_to_user_id_seq'::regclass)
calls.attendant_id calls_attendant_id_fkey
payment_renegotiation.responsible_id payment_renegotiation_responsible_id_fkey
receiving_order.responsible_id receiving_order_responsible_id_fkey
transaction_entry.user_id transaction_entry_user_id_fkey
is_active person_adapt_to_user bool 1  √  null
original_id person_adapt_to_user int8 19  √  null
person.id person_adapt_to_user_original_id_fkey
password person_adapt_to_user text 2147483647  √  null
profile_id person_adapt_to_user int8 19  √  null
user_profile.id person_adapt_to_user_profile_id_fkey
te_created_id person_adapt_to_user int8 19  √  null
transaction_entry.id person_adapt_to_user_te_created_id_fkey
te_modified_id person_adapt_to_user int8 19  √  null
transaction_entry.id person_adapt_to_user_te_modified_id_fkey
username person_adapt_to_user text 2147483647
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_retention_history.product_id product_retention_history_product_id_fkey
product_supplier_info.product_id product_supplier_info_product_id_fkey
image product bytea 2147483647  √  null
location product text 2147483647  √  null
manufacturer product text 2147483647  √  null
part_number product text 2147483647  √  null
sellable_id product int8 19  √  null
sellable.id product_sellable_id_fkey
te_created_id product int8 19  √  null
transaction_entry.id product_te_created_id_fkey
te_modified_id product int8 19  √  null
transaction_entry.id product_te_modified_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
maximum_quantity product_adapt_to_storable numeric 10,2  √  0
minimum_quantity product_adapt_to_storable numeric 10,2  √  0
original_id product_adapt_to_storable int8 19  √  null
product.id product_adapt_to_storable_original_id_fkey
te_created_id product_adapt_to_storable int8 19  √  null
transaction_entry.id product_adapt_to_storable_te_created_id_fkey
te_modified_id product_adapt_to_storable int8 19  √  null
transaction_entry.id product_adapt_to_storable_te_modified_id_fkey
component_id product_component int8 19  √  null
product.id product_component_component_id_fkey
id product_component bigserial 19  √  nextval('product_component_id_seq'::regclass)
product_id product_component int8 19  √  null
product.id product_component_product_id_fkey
quantity product_component numeric 10,2  √  null
te_created_id product_component int8 19  √  null
transaction_entry.id product_component_te_created_id_fkey
te_modified_id product_component int8 19  √  null
transaction_entry.id product_component_te_modified_id_fkey
branch_id product_history int8 19  √  null
person_adapt_to_branch.id product_history_branch_id_fkey
id product_history bigserial 19  √  nextval('product_history_id_seq'::regclass)
quantity_received product_history numeric 10,2  √  null
quantity_retained product_history numeric 10,2  √  null
quantity_sold product_history numeric 10,2  √  null
quantity_transfered product_history numeric 10,2  √  null
received_date product_history timestamp 29,6  √  null
sellable_id product_history int8 19  √  null
sellable.id product_history_sellable_id_fkey
sold_date product_history timestamp 29,6  √  null
te_created_id product_history int8 19  √  null
transaction_entry.id product_history_te_created_id_fkey
te_modified_id product_history int8 19  √  null
transaction_entry.id product_history_te_modified_id_fkey
cfop_id product_retention_history int8 19  √  null
cfop_data.id product_retention_history_cfop_id_fkey
id product_retention_history bigserial 19  √  nextval('product_retention_history_id_seq'::regclass)
product_id product_retention_history int8 19  √  null
product.id product_retention_history_product_id_fkey
quantity product_retention_history numeric 10,2  √  null
reason product_retention_history text 2147483647  √  null
retention_date product_retention_history timestamp 29,6  √  null
te_created_id product_retention_history int8 19  √  null
transaction_entry.id product_retention_history_te_created_id_fkey
te_modified_id product_retention_history int8 19  √  null
transaction_entry.id product_retention_history_te_modified_id_fkey
branch_id product_stock_item int8 19  √  null
person_adapt_to_branch.id product_stock_item_branch_id_fkey
id product_stock_item bigserial 19  √  nextval('product_stock_item_id_seq'::regclass)
logic_quantity product_stock_item numeric 10,2  √  null
quantity product_stock_item numeric 10,2  √  null
stock_cost product_stock_item numeric 10,2  √  null
storable_id product_stock_item int8 19  √  null
product_adapt_to_storable.id product_stock_item_storable_id_fkey
te_created_id product_stock_item int8 19  √  null
transaction_entry.id product_stock_item_te_created_id_fkey
te_modified_id product_stock_item int8 19  √  null
transaction_entry.id product_stock_item_te_modified_id_fkey
base_cost product_supplier_info numeric 10,4  √  null
icms product_supplier_info numeric 10,2  √  null
id product_supplier_info bigserial 19  √  nextval('product_supplier_info_id_seq'::regclass)
is_main_supplier product_supplier_info bool 1  √  null
lead_time product_supplier_info int4 10  √  1
minimum_purchase product_supplier_info numeric 10,2  √  1
notes product_supplier_info text 2147483647  √  null
product_id product_supplier_info int8 19
product.id product_supplier_info_product_id_fkey
supplier_id product_supplier_info int8 19
person_adapt_to_supplier.id product_supplier_info_supplier_id_fkey
te_created_id product_supplier_info int8 19  √  null
transaction_entry.id product_supplier_info_te_created_id_fkey
te_modified_id product_supplier_info int8 19  √  null
transaction_entry.id product_supplier_info_te_modified_id_fkey
app_dir_name profile_settings text 2147483647  √  null
has_permission profile_settings bool 1  √  null
id profile_settings bigserial 19  √  nextval('profile_settings_id_seq'::regclass)
te_created_id profile_settings int8 19  √  null
transaction_entry.id profile_settings_te_created_id_fkey
te_modified_id profile_settings int8 19  √  null
transaction_entry.id profile_settings_te_modified_id_fkey
user_profile_id profile_settings int8 19  √  null
user_profile.id profile_settings_user_profile_id_fkey
base_cost purchase_item numeric 10,4  √  null
cost purchase_item numeric 10,4  √  null
expected_receival_date purchase_item timestamp 29,6  √  null
id purchase_item bigserial 19  √  nextval('purchase_item_id_seq'::regclass)
receiving_order_item.purchase_item_id receiving_order_item_purchase_item_id_fkey
order_id purchase_item int8 19  √  null
purchase_order.id purchase_item_order_id_fkey
quantity purchase_item numeric 10,2  √  null
quantity_received purchase_item numeric 10,2  √  null
sellable_id purchase_item int8 19  √  null
sellable.id purchase_item_sellable_id_fkey
te_created_id purchase_item int8 19  √  null
transaction_entry.id purchase_item_te_created_id_fkey
te_modified_id purchase_item int8 19  √  null
transaction_entry.id purchase_item_te_modified_id_fkey
branch_id purchase_order int8 19  √  null
person_adapt_to_branch.id purchase_order_branch_id_fkey
confirm_date purchase_order timestamp 29,6  √  null
discount_value purchase_order numeric 10,2  √  null
expected_freight purchase_order numeric 10,2  √  null
expected_pay_date purchase_order timestamp 29,6  √  null
expected_receival_date purchase_order timestamp 29,6  √  null
freight_type purchase_order int4 10  √  null
group_id purchase_order int8 19  √  null
payment_group.id purchase_order_group_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
is_valid_model purchase_order bool 1  √  null
notes purchase_order text 2147483647  √  null
open_date purchase_order timestamp 29,6  √  null
quote_deadline purchase_order timestamp 29,6  √  null
receival_date purchase_order timestamp 29,6  √  null
salesperson_name purchase_order text 2147483647  √  null
status purchase_order int4 10  √  null
supplier_id purchase_order int8 19  √  null
person_adapt_to_supplier.id purchase_order_supplier_id_fkey
surcharge_value purchase_order numeric 10,2  √  null
te_created_id purchase_order int8 19  √  null
transaction_entry.id purchase_order_te_created_id_fkey
te_modified_id purchase_order int8 19  √  null
transaction_entry.id purchase_order_te_modified_id_fkey
transporter_id purchase_order int8 19  √  null
person_adapt_to_transporter.id purchase_order_transporter_id_fkey
group_id quotation int8 19  √  null
quote_group.id quotation_group_id_fkey
id quotation bigserial 19  √  nextval('quotation_id_seq'::regclass)
purchase_id quotation int8 19  √  null
purchase_order.id quotation_purchase_id_fkey
te_created_id quotation int8 19  √  null
transaction_entry.id quotation_te_created_id_fkey
te_modified_id quotation int8 19  √  null
transaction_entry.id quotation_te_modified_id_fkey
id quote_group bigserial 19  √  nextval('quote_group_id_seq'::regclass)
quotation.group_id quotation_group_id_fkey
te_created_id quote_group int8 19  √  null
transaction_entry.id quote_group_te_created_id_fkey
te_modified_id quote_group int8 19  √  null
transaction_entry.id quote_group_te_modified_id_fkey
branch_id receiving_order int8 19  √  null
person_adapt_to_branch.id receiving_order_branch_id_fkey
cfop_id receiving_order int8 19  √  null
cfop_data.id receiving_order_cfop_id_fkey
confirm_date receiving_order timestamp 29,6  √  null
discount_value receiving_order numeric 10,2  √  null
expense_value receiving_order numeric 10,2  √  null
freight_total receiving_order numeric 10,2  √  null
icms_total receiving_order numeric 10,2  √  null
id receiving_order bigserial 19  √  nextval('receiving_order_id_seq'::regclass)
receiving_order_item.receiving_order_id receiving_order_item_receiving_order_id_fkey
invoice_number receiving_order int4 10  √  null
invoice_total receiving_order numeric 10,2  √  null
ipi_total receiving_order numeric 10,2  √  null
is_valid_model receiving_order bool 1  √  null
notes receiving_order text 2147483647  √  null
purchase_id receiving_order int8 19
purchase_order.id receiving_order_purchase_id_fkey
receival_date receiving_order timestamp 29,6  √  null
responsible_id receiving_order int8 19  √  null
person_adapt_to_user.id receiving_order_responsible_id_fkey
secure_value receiving_order numeric 10,2  √  null
status receiving_order int4 10  √  null
supplier_id receiving_order int8 19  √  null
person_adapt_to_supplier.id receiving_order_supplier_id_fkey
surcharge_value receiving_order numeric 10,2  √  null
te_created_id receiving_order int8 19  √  null
transaction_entry.id receiving_order_te_created_id_fkey
te_modified_id receiving_order int8 19  √  null
transaction_entry.id receiving_order_te_modified_id_fkey
transporter_id receiving_order int8 19  √  null
person_adapt_to_transporter.id receiving_order_transporter_id_fkey
cost receiving_order_item numeric 10,4  √  null
id receiving_order_item bigserial 19  √  nextval('receiving_order_item_id_seq'::regclass)
purchase_item_id receiving_order_item int8 19  √  null
purchase_item.id receiving_order_item_purchase_item_id_fkey
quantity receiving_order_item numeric 10,2  √  null
receiving_order_id receiving_order_item int8 19  √  null
receiving_order.id receiving_order_item_receiving_order_id_fkey
sellable_id receiving_order_item int8 19  √  null
sellable.id receiving_order_item_sellable_id_fkey
te_created_id receiving_order_item int8 19  √  null
transaction_entry.id receiving_order_item_te_created_id_fkey
te_modified_id receiving_order_item int8 19  √  null
transaction_entry.id receiving_order_item_te_modified_id_fkey
id renegotiation_data bigserial 19  √  nextval('renegotiation_data_id_seq'::regclass)
invoice_number renegotiation_data int4 10  √  null
new_order_id renegotiation_data int8 19  √  null
sale.id renegotiation_data_new_order_id_fkey
paid_total renegotiation_data numeric 10,2  √  null
penalty_value renegotiation_data numeric 10,2  √  null
reason renegotiation_data text 2147483647  √  null
responsible_id renegotiation_data int8 19  √  null
person.id renegotiation_data_responsible_id_fkey
sale_id renegotiation_data int8 19  √  null
sale.id renegotiation_data_sale_id_fkey
te_created_id renegotiation_data int8 19  √  null
transaction_entry.id renegotiation_data_te_created_id_fkey
te_modified_id renegotiation_data int8 19  √  null
transaction_entry.id renegotiation_data_te_modified_id_fkey
branch_id sale int8 19  √  null
person_adapt_to_branch.id sale_branch_id_fkey
cancel_date sale timestamp 29,6  √  null
cfop_id sale int8 19  √  null
cfop_data.id sale_cfop_id_fkey
client_id sale int8 19  √  null
person_adapt_to_client.id sale_client_id_fkey
close_date sale timestamp 29,6  √  null
confirm_date sale timestamp 29,6  √  null
coupon_id sale int4 10  √  null
discount_value sale numeric 10,2  √  null
expire_date sale timestamp 29,6  √  null
group_id sale int8 19  √  null
payment_group.id sale_group_id_fkey
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
invoice_number sale int4 10  √  null
is_valid_model sale bool 1  √  null
notes sale text 2147483647  √  null
open_date sale timestamp 29,6  √  null
return_date sale timestamp 29,6  √  null
salesperson_id sale int8 19  √  null
person_adapt_to_sales_person.id sale_salesperson_id_fkey
service_invoice_number sale int4 10  √  null
status sale int4 10  √  null
surcharge_value sale numeric 10,2  √  null
te_created_id sale int8 19  √  null
transaction_entry.id sale_te_created_id_fkey
te_modified_id sale int8 19  √  null
transaction_entry.id sale_te_modified_id_fkey
total_amount sale numeric 10,2  √  null
base_price sale_item numeric 10,2  √  null
completion_date sale_item timestamp 29,6  √  null
estimated_fix_date sale_item timestamp 29,6  √  null
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
notes sale_item text 2147483647  √  null
price sale_item numeric 10,2  √  null
quantity sale_item numeric 10,2  √  null
sale_id sale_item int8 19  √  null
sale.id sale_item_sale_id_fkey
sellable_id sale_item int8 19  √  null
sellable.id sale_item_sellable_id_fkey
te_created_id sale_item int8 19  √  null
transaction_entry.id sale_item_te_created_id_fkey
te_modified_id sale_item int8 19  √  null
transaction_entry.id sale_item_te_modified_id_fkey
address sale_item_adapt_to_delivery text 2147483647  √  null
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
original_id sale_item_adapt_to_delivery int8 19  √  null
sale_item.id sale_item_adapt_to_delivery_original_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_modified_id sale_item_adapt_to_delivery int8 19  √  null
transaction_entry.id sale_item_adapt_to_delivery_te_modified_id_fkey
barcode sellable text 2147483647  √  null
base_sellable_info_id sellable int8 19  √  null
base_sellable_info.id sellable_base_sellable_info_id_fkey
category_id sellable int8 19  √  null
sellable_category.id sellable_category_id_fkey
code sellable text 2147483647  √  null
cost sellable numeric 10,4  √  null
id sellable bigserial 19  √  nextval('sellable_id_seq'::regclass)
commission_source.sellable_id commission_source_asellable_id_fkey
delivery_item.sellable_id delivery_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
transfer_order_item.sellable_id transfer_order_item_sellable_id_fkey
notes sellable text 2147483647  √  null
on_sale_info_id sellable int8 19  √  null
on_sale_info.id sellable_on_sale_info_id_fkey
status sellable int4 10  √  null
tax_constant_id sellable int8 19  √  null
sellable_tax_constant.id sellable_tax_constant_id_fkey
te_created_id sellable int8 19  √  null
transaction_entry.id sellable_te_created_id_fkey
te_modified_id sellable int8 19  √  null
transaction_entry.id sellable_te_modified_id_fkey
unit_id sellable int8 19  √  null
sellable_unit.id sellable_unit_id_fkey
category_id sellable_category int8 19  √  null
sellable_category.id sellable_category_category_id_fkey
description sellable_category text 2147483647  √  null
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
salesperson_commission sellable_category numeric 10,2  √  null
suggested_markup sellable_category numeric 10,2  √  null
tax_constant_id sellable_category int8 19  √  null
sellable_tax_constant.id sellable_category_tax_constant_id_fkey
te_created_id sellable_category int8 19  √  null
transaction_entry.id sellable_category_te_created_id_fkey
te_modified_id sellable_category int8 19  √  null
transaction_entry.id sellable_category_te_modified_id_fkey
description sellable_tax_constant text 2147483647  √  null
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
tax_type sellable_tax_constant int4 10  √  null
tax_value sellable_tax_constant numeric 10,2  √  null
te_created_id sellable_tax_constant int8 19  √  null
transaction_entry.id sellable_tax_constant_te_created_id_fkey
te_modified_id sellable_tax_constant int8 19  √  null
transaction_entry.id sellable_tax_constant_te_modified_id_fkey
description sellable_unit text 2147483647  √  null
id sellable_unit bigserial 19  √  nextval('sellable_unit_id_seq'::regclass)
sellable.unit_id sellable_unit_id_fkey
te_created_id sellable_unit int8 19  √  null
transaction_entry.id sellable_unit_te_created_id_fkey
te_modified_id sellable_unit int8 19  √  null
transaction_entry.id sellable_unit_te_modified_id_fkey
unit_index sellable_unit int4 10  √  null
id service bigserial 19  √  nextval('service_id_seq'::regclass)
image service bytea 2147483647  √  null
sellable_id service int8 19  √  null
sellable.id service_sellable_id_fkey
te_created_id service int8 19  √  null
transaction_entry.id service_te_created_id_fkey
te_modified_id service int8 19  √  null
transaction_entry.id service_te_modified_id_fkey
generation system_table int4 10  √  null
id system_table bigserial 19  √  nextval('system_table_id_seq'::regclass)
patchlevel system_table int4 10  √  null
updated system_table timestamp 29,6  √  null
closing_date till timestamp 29,6  √  null
final_cash_amount till numeric 10,2  √  null
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
initial_cash_amount till numeric 10,2  √  null
opening_date till timestamp 29,6  √  null
station_id till int8 19  √  null
branch_station.id till_station_id_fkey
status till int4 10  √  null
te_created_id till int8 19  √  null
transaction_entry.id till_te_created_id_fkey
te_modified_id till int8 19  √  null
transaction_entry.id till_te_modified_id_fkey
date till_entry timestamp 29,6  √  null
description till_entry text 2147483647  √  null
id till_entry bigserial 19  √  nextval('till_entry_id_seq'::regclass)
payment_id till_entry int4 10  √  null
te_created_id till_entry int8 19  √  null
transaction_entry.id till_entry_te_created_id_fkey
te_modified_id till_entry int8 19  √  null
transaction_entry.id till_entry_te_modified_id_fkey
till_id till_entry int8 19
till.id till_entry_till_id_fkey
value till_entry numeric 10,2  √  null
id transaction_entry bigserial 19  √  nextval('transaction_entry_id_seq'::regclass)
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
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
credit_provider_group_data.te_created_id credit_provider_group_data_te_created_id_fkey
credit_provider_group_data.te_modified_id credit_provider_group_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
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_destination.te_created_id payment_destination_te_created_id_fkey
payment_destination.te_modified_id payment_destination_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_retention_history.te_created_id product_retention_history_te_created_id_fkey
product_retention_history.te_modified_id product_retention_history_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
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