SchemaSpy - Table stoq_schema.public.commission

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

commission_te_id_fkey R

value

numeric

20,2

commission_type

int4

10

sale_id

uuid

2147483647

sale.id

commission_sale_id_fkey R

payment_id

uuid

2147483647

payment.id

commission_payment_id_fkey R

Analyzed at Fri Jun 10 16:06 BRT 2016

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	commission_pkey
payment_id	Must be unique	Asc	commission_payment_id_key
te_id	Must be unique	Asc	commission_te_id_key	This unique column is also nullable