Table alter.public.mis_product_lots
Anagrafica lotti (matricole).

 Generated by
SchemaSpy
Implied relationships 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
lot_id int4 10
mis_delivery_note_lines.lot_id mis_delivery_note_lines_lot_id_fkey
mis_fast_delivery_note_lines.lot_id Implied Constraint
mis_inventories.inv_lot_id mis_inventories_inv_lot_id_fkey
mis_wh_mov.wh_mov_lot_id mis_wh_mov_wh_mov_lot_id_fkey
product_id int4 10
mis_products.product_id mis_product_lots_product_id_fkey
lot_no varchar 20  √  null
lot_description varchar 50  √  null
lot_source varchar 50  √  null Fonte: attualmente non usata.
lot_po_id int4 10  √  null Riferimento all'ordine fornitore.

Table contained 0 rows at Fri Feb 29 12:05 CET 2008

Indexes:
Column(s) Type Sort Constraint Name
lot_id Primary key Asc mis_product_lots_pkey
product_id + lot_no Must be unique Asc/Asc mis_product_lots_indx1

Close relationships  within one two degrees of separation :