I currently have 3 tables:
stock, which are pretty self-explanatory:
The fields of
quantity, which is great... until I add a new location (or product, but less so, since the number of locations is normally quite small).
In production, we have 20k+ products, which means that if a new location is created, 200k+ records must be created in stock, which seems quite ridiculous to me. I'm sure it's not that bad in reality, but it still feels like something that should be avoided.
So, is there any better way to do this, or is this the normal best practice?