How would you create a database that sells products of the same cost for each size range.
Current Products Table:
- Product 1 of 1mm
- Product 1 of 2mm
- Product 1 of 3mm
- Etc up to 1000mm
Does it make sense to store it as mentioned above?
Or would you you store it as:
- Product 1, minimum length 1mm, maximum length 1000mm
Each sale line will mention the exact size sold.