SchemaSpy - Table stoq_schema.public.user_branch_access

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

te_id

int8

19

√

new_te()

transaction_entry.id

user_branch_access_te_id_fkey R

user_id

uuid

2147483647

user_branch_access_user_id_fkey R

branch_id

uuid

2147483647

branch.id

user_branch_access_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	user_branch_access_pkey
te_id	Must be unique	Asc	user_branch_access_te_id_key	This unique column is also nullable
user_id + branch_id	Must be unique	Asc/Asc	user_branch_access_user_id_branch_id_key