Table alter.public.mis_inventories Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
inventory_id int4 10
inv_product_id int4 10
mis_products.product_id mis_inventories_inv_product_id_fkey
inv_store_id int4 10
mis_stores.store_id mis_inventories_inv_store_id_fkey
inv_account_id int4 10  √  null Se il campo è nullo si assume che sia imputato a 'STOCK'
inv_location_id int4 10  √  null
mis_store_locations.location_id mis_inventories_inv_location_id_fkey
inv_lot_id int4 10  √  null
mis_product_lots.lot_id mis_inventories_inv_lot_id_fkey
inv_qty numeric 11,2  √  0

Table contained 2,151 rows at Fri Feb 29 12:05 CET 2008

Indexes:
Column(s) Type Sort Constraint Name
inventory_id Primary key Asc mis_inventories_pkey
inv_product_id + inv_store_id + inv_account_id + inv_lot_id + inv_location_id Must be unique Asc/Asc/Asc/Asc/Asc mis_inventories_indx1

Close relationships  within one two degrees of separation :