SchemaSpy - Table stoq_schema.public.product_stock

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

uuid

2147483647

uuid_generate_v1()

stock_transaction_history.product_stock_item_id

stock_transaction_history_product_stock_item_id_fkey R

te_id

int8

√

new_te()

transaction_entry.id

product_stock_item_te_id_fkey R

stock_cost

numeric

20,8

√

null

quantity

numeric

20,3

√

null

storable_id

uuid

2147483647

√

null

storable.id

product_stock_item_storable_id_fkey R

batch_id

uuid

2147483647

√

null

storable_batch.id

product_stock_item_batch_id_fkey R

branch_id

uuid

2147483647

branch.id

product_stock_item_branch_id_fkey R

Analyzed at Mon Nov 09 14:32 BRST 2015

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	product_stock_item_pkey
branch_id + storable_id + batch_id	Must be unique	Asc/Asc/Asc	product_stock_item_branch_id_storable_id_batch_id_key
te_id	Must be unique	Asc	product_stock_item_te_id_key	This unique column is also nullable