SchemaSpy - Table stoq_schema.public.transaction

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

bigserial

√

nextval('transaction_entry_id_seq'::regclass)

account.te_id	account_te_id_fkey R
account_transaction.te_id	account_transaction_te_id_fkey R
address.te_id	address_te_id_fkey R
attachment.te_id	attachment_te_id_fkey R
bank_account.te_id	bank_account_te_id_fkey R
bill_option.te_id	bill_option_te_id_fkey R
branch.te_id	branch_te_id_fkey R
branch_station.te_id	branch_station_te_id_fkey R
calls.te_id	calls_te_id_fkey R
card_operation_cost.te_id	card_operation_cost_te_id_fkey R
card_payment_device.te_id	card_payment_device_te_id_fkey R
cfop_data.te_id	cfop_data_te_id_fkey R
check_data.te_id	check_data_te_id_fkey R
client.te_id	client_te_id_fkey R
client_category.te_id	client_category_te_id_fkey R
client_category_price.te_id	client_category_price_te_id_fkey R
client_salary_history.te_id	client_salary_history_te_id_fkey R
commission.te_id	commission_te_id_fkey R
commission_source.te_id	commission_source_te_id_fkey R
company.te_id	company_te_id_fkey R
contact_info.te_id	contact_info_te_id_fkey R
cost_center.te_id	cost_center_te_id_fkey R
cost_center_entry.te_id	cost_center_entry_te_id_fkey R
credit_card_data.te_id	credit_card_data_te_id_fkey R
credit_check_history.te_id	credit_check_history_te_id_fkey R
credit_provider.te_id	credit_provider_te_id_fkey R
delivery.te_id	delivery_te_id_fkey R
device_constant.te_id	device_constant_te_id_fkey R
device_settings.te_id	device_settings_te_id_fkey R
employee.te_id	employee_te_id_fkey R
employee_role.te_id	employee_role_te_id_fkey R
employee_role_history.te_id	employee_role_history_te_id_fkey R
fiscal_book_entry.te_id	fiscal_book_entry_te_id_fkey R
fiscal_day_history.te_id	fiscal_day_history_te_id_fkey R
fiscal_day_tax.te_id	fiscal_day_tax_te_id_fkey R
fiscal_sale_history.te_id	fiscal_sale_history_te_id_fkey R
grid_attribute.te_id	grid_attribute_te_id_fkey R
grid_group.te_id	grid_group_te_id_fkey R
grid_option.te_id	grid_option_te_id_fkey R
image.te_id	image_te_id_fkey R
individual.te_id	individual_te_id_fkey R
installed_plugin.te_id	installed_plugin_te_id_fkey R
inventory.te_id	inventory_te_id_fkey R
inventory_item.te_id	inventory_item_te_id_fkey R
invoice.te_id	invoice_te_id_fkey R
invoice_field.te_id	invoice_field_te_id_fkey R
invoice_item_cofins.te_id	invoice_item_cofins_te_id_fkey R
invoice_item_icms.te_id	invoice_item_icms_te_id_fkey R
invoice_item_ipi.te_id	invoice_item_ipi_te_id_fkey R
invoice_item_pis.te_id	invoice_item_pis_te_id_fkey R
invoice_layout.te_id	invoice_layout_te_id_fkey R
invoice_printer.te_id	invoice_printer_te_id_fkey R
loan.te_id	loan_te_id_fkey R
loan_item.te_id	loan_item_te_id_fkey R
login_user.te_id	login_user_te_id_fkey R
military_data.te_id	military_data_te_id_fkey R
parameter_data.te_id	parameter_data_te_id_fkey R
payment.te_id	payment_te_id_fkey R
payment_category.te_id	payment_category_te_id_fkey R
payment_change_history.te_id	payment_change_history_te_id_fkey R
payment_comment.te_id	payment_comment_te_id_fkey R
payment_flow_history.te_id	payment_flow_history_te_id_fkey R
payment_group.te_id	payment_group_te_id_fkey R
payment_method.te_id	payment_method_te_id_fkey R
payment_renegotiation.te_id	payment_renegotiation_te_id_fkey R
person.te_id	person_te_id_fkey R
plugin_egg.te_id	plugin_egg_te_id_fkey R
product.te_id	product_te_id_fkey R
product_attribute.te_id	product_attribute_te_id_fkey R
product_cofins_template.te_id	product_cofins_template_te_id_fkey R
product_component.te_id	product_component_te_id_fkey R
product_history.te_id	product_history_te_id_fkey R
product_icms_template.te_id	product_icms_template_te_id_fkey R
product_ipi_template.te_id	product_ipi_template_te_id_fkey R
product_manufacturer.te_id	product_manufacturer_te_id_fkey R
product_option_map.te_id	product_option_map_te_id_fkey R
product_pis_template.te_id	product_pis_template_te_id_fkey R
product_quality_test.te_id	product_quality_test_te_id_fkey R
product_stock_item.te_id	product_stock_item_te_id_fkey R
product_supplier_info.te_id	product_supplier_info_te_id_fkey R
product_tax_template.te_id	product_tax_template_te_id_fkey R
production_item.te_id	production_item_te_id_fkey R
production_item_quality_result.te_id	production_item_quality_result_te_id_fkey R
production_material.te_id	production_material_te_id_fkey R
production_order.te_id	production_order_te_id_fkey R
production_produced_item.te_id	production_produced_item_te_id_fkey R
production_service.te_id	production_service_te_id_fkey R
profile_settings.te_id	profile_settings_te_id_fkey R
purchase_item.te_id	purchase_item_te_id_fkey R
purchase_order.te_id	purchase_order_te_id_fkey R
purchase_receiving_map.te_id	purchase_receiving_map_te_id_fkey R
quotation.te_id	quotation_te_id_fkey R
quote_group.te_id	quote_group_te_id_fkey R
receiving_order.te_id	receiving_order_te_id_fkey R
receiving_order_item.te_id	receiving_order_item_te_id_fkey R
returned_sale.te_id	returned_sale_te_id_fkey R
returned_sale_item.te_id	returned_sale_item_te_id_fkey R
sale.te_id	sale_te_id_fkey R
sale_comment.te_id	sale_comment_te_id_fkey R
sale_item.te_id	sale_item_te_id_fkey R
sale_token.te_id	sale_token_te_id_fkey R
sales_person.te_id	sales_person_te_id_fkey R
sellable.te_id	sellable_te_id_fkey R
sellable_category.te_id	sellable_category_te_id_fkey R
sellable_tax_constant.te_id	sellable_tax_constant_te_id_fkey R
sellable_unit.te_id	sellable_unit_te_id_fkey R
service.te_id	service_te_id_fkey R
stock_decrease.te_id	stock_decrease_te_id_fkey R
stock_decrease_item.te_id	stock_decrease_item_te_id_fkey R
stock_transaction_history.te_id	stock_transaction_history_te_id_fkey R
storable.te_id	storable_te_id_fkey R
storable_batch.te_id	storable_batch_te_id_fkey R
supplier.te_id	supplier_te_id_fkey R
till.te_id	till_te_id_fkey R
till_entry.te_id	till_entry_te_id_fkey R
transfer_order.te_id	transfer_order_te_id_fkey R
transfer_order_item.te_id	transfer_order_item_te_id_fkey R
transporter.te_id	transporter_te_id_fkey R
ui_field.te_id	ui_field_te_id_fkey R
ui_form.te_id	ui_form_te_id_fkey R
user_branch_access.te_id	user_branch_access_te_id_fkey R
user_profile.te_id	user_profile_te_id_fkey R
voter_data.te_id	voter_data_te_id_fkey R
work_order.te_id	work_order_te_id_fkey R
work_order_category.te_id	work_order_category_te_id_fkey R
work_order_history.te_id	work_order_history_te_id_fkey R
work_order_item.te_id	work_order_item_te_id_fkey R
work_order_package.te_id	work_order_package_te_id_fkey R
work_order_package_item.te_id	work_order_package_item_te_id_fkey R
work_permit_data.te_id	work_permit_data_te_id_fkey R

te_time

timestamp

29,6

dirty

bool

√

true

Analyzed at Fri Jun 10 16:06 BRT 2016

Indexes:

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