Table george.public.transaction_entry Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
id 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 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
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
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
te_time timestamp 29,6
user_id int4 10  √  null
person_adapt_to_user.id transaction_entry_user_id_fkey
station_id int4 10  √  null
branch_station.id transaction_entry_station_id_fkey
type int4 10  √  null

Table contained 876 rows at Tue Jul 14 15:21 GMT-03:00 2009

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc transaction_entry_pkey

Close relationships  within one two degrees of separation :