My question is that if I have a product table and an inventory table, it will save the amount of product that I have in total, but in the product table will keep each product regardless of the same? I mean, if I buy 50 soft drinks and X the supplier, I'll have 50 soda records in the product table?
Most of all, I say this because of the expiration date that I have to put on the product I bought and if I only update the amount in the store then I will not know when the product expires.
and if it is in this way, then when selling products will the amount sold be eliminated from the product table?
How is the sale and purchase of products handled?