Greeting my friends..
Am working on web application (Training app.)
I designed a database from scratch and I face this theoretical problem
I have a SQL table to [store section] as this photo
All columns value have low number of quantity which not allow to decrease it as example:
Not allowed being a flour quantity less than 50 kilogram.
Scenario :
A [store section] following to chocolate shop..
another section called [Kitchen]..
there are daily orders from Kitchen to store ( to request a required quantity from [flour, egg, butter, milk, etc]
So if today a kitchen sent quantity order to Store section [ I need 30 kilograms of flour], a scenario designed to substruct each order value from column value..
To inform a Storekeeper and admin by alert
("Your quantity of flour be close to 50 kilograms, you should bye new quantity of this material)..
A followed Solution:
Can I do a last scenario by SQL stored Procedure and apply it to check each column quantity in each (Import/export) orders).
Or design it by SQl function.
I hope to provide me your opinion...
Thanks