0

I am looking for some review on the following schema I've worked on for an inventory management system.

It will be used in a govrenmental facility for managing item issuance to employees, to have a better understanding on which employee has what item, along with the issuance details.

Database Schema

2
  • So partial returns are allowed? Is it possible to return an item without it being issued?...for example when a lost item is found?
    – J.D.
    Feb 7 at 13:42
  • To be honest, if it was me, I'd probably just be inclined to have a single table that recorded "issues" (say, as positive values) and "returns" (as negative values). If you think about what "Inventory Management" usually encompasses, it is different transactions occurring on items, and those transactions would - from a very simple perspective - be considered "ins" and "outs"
    – Craig
    Feb 9 at 3:15

0