SchemaSpy - Table stoq_schema.public.branch_station

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()

account.station_id	account_station_id_fkey R
device_settings.station_id	device_settings_station_id_fkey R
fiscal_day_history.station_id	fiscal_day_history_station_id_fkey R
invoice_printer.station_id	invoice_printer_station_id_fkey R
till.station_id	till_station_id_fkey R

te_id

int8

19

√

new_te()

transaction_entry.id

branch_station_te_id_fkey R

name

text

2147483647

√

null

is_active

bool

1

√

null

branch_id

uuid

2147483647

√

null

branch.id

branch_station_branch_id_fkey R

Analyzed at Fri Jun 10 16:06 BRT 2016

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	branch_station_pkey
name	Must be unique	Asc	branch_station_name_key	This unique column is also nullable
te_id	Must be unique	Asc	branch_station_te_id_key	This unique column is also nullable