As there is only one warehouse and one scaffolding, just the shelves (storage locations) are relevant.
You need (at least) three tables:

  • StorageLocation
  • Product
  • StockMovement.


In the StockMovement table you will fields like:
  • StorageLocationID
  • ProductID
  • Quantity (+ or -)
  • Date/time.