Table jdahlin.public.transaction_entry

Generated by SchemaSpy

Related columns Constraint names Comments Legend

Legend: 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) 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 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 1.152 rows at Sex Jun 10 16:28 BRT 2011

SchemaSpy was unable to generate a graphical representation of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.