Best way to check column value.

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta6y ago
You can choose to alert the user at the time of sale/purchase of product. If user want repetitive reminders then you can store that product id and at the specific interval, just check the quantity and notify the user.