stockrotationitems

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
itemnumber_id INT 10 null
items.itemnumber stockrotationitems_iifkC

Itemnumber to link to a stage & rota

stage_id INT 10 null
stockrotationstages.stage_id stockrotationitems_sifkC

stage ID to link the item to

indemand BIT 0 0

Should this item be skipped for rotation?

fresh BIT 0 0

Flag showing item is only just added to rota

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc itemnumber_id
stockrotationitems_sifk Performance Asc stage_id

Relationships