SchemaSpy - Table stoq_schema.public.user_profile

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

login_user.profile_id	login_user_profile_id_fkey R
profile_settings.user_profile_id	profile_settings_user_profile_id_fkey R

te_id

int8

19

√

new_te()

transaction_entry.id

user_profile_te_id_fkey R

name

text

2147483647

√

null

max_discount

numeric

10,2

√

0

Analyzed at Mon Nov 09 14:32 BRST 2015

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	user_profile_pkey
te_id	Must be unique	Asc	user_profile_te_id_key	This unique column is also nullable