SchemaSpy - Table stoq_schema.public.branch

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

id

uuid

2147483647

uuid_generate_v1()

branch_station.branch_id	branch_station_branch_id_fkey R
branch_synchronization.branch_id	branch_synchronization_branch_id_fkey R
employee.branch_id	employee_branch_id_fkey R
fiscal_book_entry.branch_id	fiscal_book_entry_branch_id_fkey R
inventory.branch_id	inventory_branch_id_fkey R
invoice.branch_id	invoice_branch_id_fkey R
loan.branch_id	loan_branch_id_fkey R
payment.branch_id	payment_branch_id_fkey R
payment_renegotiation.branch_id	payment_renegotiation_branch_id_fkey R
product_history.branch_id	product_history_branch_id_fkey R
product_stock_item.branch_id	product_stock_item_branch_id_fkey R
production_order.branch_id	production_order_branch_id_fkey R
purchase_order.branch_id	purchase_order_branch_id_fkey R
quotation.branch_id	quotation_branch_id_fkey R
quote_group.branch_id	quote_group_branch_id_fkey R
receiving_order.branch_id	receiving_order_branch_id_fkey R
returned_sale.branch_id	returned_sale_branch_id_fkey R
sale.branch_id	sale_branch_id_fkey R
stock_decrease.branch_id	stock_decrease_branch_id_fkey R
stock_transaction_history.branch_id	stock_transaction_history_branch_id_fkey R
till_entry.branch_id	till_entry_branch_id_fkey R
transfer_order.destination_branch_id	transfer_order_destination_branch_id_fkey R
transfer_order.source_branch_id	transfer_order_source_branch_id_fkey R
user_branch_access.branch_id	user_branch_access_branch_id_fkey R
work_order.branch_id	work_order_branch_id_fkey R
work_order.current_branch_id	work_order_current_branch_id_fkey R
work_order.execution_branch_id	work_order_execution_branch_id_fkey R
work_order_package.destination_branch_id	work_order_package_destination_branch_id_fkey R
work_order_package.source_branch_id	work_order_package_source_branch_id_fkey R

te_id

int8

19

√

new_te()

transaction_entry.id

branch_te_id_fkey R

manager_id

uuid

2147483647

√

null

employee.id

branch_manager_id_fkey R

is_active

bool

1

√

null

crt

int4

10

√

1

acronym

text

2147483647

√

null

person_id

uuid

2147483647

√

null

person.id

branch_person_id_fkey R

can_execute_foreign_work_orders

bool

1

√

false

Analyzed at Fri Jun 10 16:06 BRT 2016

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	branch_pkey
acronym	Must be unique	Asc	branch_acronym_key	This unique column is also nullable
person_id	Must be unique	Asc	branch_person_id_key	This unique column is also nullable
te_id	Must be unique	Asc	branch_te_id_key	This unique column is also nullable