In our project, every time we get a new product from a Donor, we use InventoryNumber table to assign
inventory_number to that product. InventoryNumber table has just two columns :
(id, code). Code is nothing but the
inventory_number that needs to be assigned to the product.
inventory_number needs to be auto-generated for every product and gets added to the InventoryNumber table once the the product is accepted by one of the admin. Also the interesting part is this
inventory_number can also be...