SchemaSpy - Table stoq_schema.public.storable_batch

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

inventory_item.batch_id	inventory_item_batch_id_fkey R
loan_item.batch_id	loan_item_batch_id_fkey R
product_stock_item.batch_id	product_stock_item_batch_id_fkey R
receiving_order_item.batch_id	receiving_order_item_batch_id_fkey R
returned_sale_item.batch_id	returned_sale_item_batch_id_fkey R
sale_item.batch_id	sale_item_batch_id_fkey R
stock_decrease_item.batch_id	stock_decrease_item_batch_id_fkey R
transfer_order_item.batch_id	transfer_order_item_batch_id_fkey R
work_order_item.batch_id	work_order_item_batch_id_fkey R

te_id

int8

19

√

new_te()

transaction_entry.id

storable_batch_te_id_fkey R

batch_number

text

2147483647

create_date

timestamp

29,6

expire_date

timestamp

29,6

√

null

notes

text

2147483647

√

null

storable_id

uuid

2147483647

storable.id

storable_batch_storable_id_fkey R

Analyzed at Mon Nov 09 14:32 BRST 2015

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	storable_batch_pkey
batch_number	Must be unique	Asc	storable_batch_batch_number_key
te_id	Must be unique	Asc	storable_batch_te_id_key	This unique column is also nullable