I am still struggling with my database design though I have narrowed down my problem. (I think)
I am trying to build a quotation system where the user can select one or more base product (PIECE) and can then add zero or one or more products (ADDON).
I have grouped together the add-on and base products together as they carry the same attributes. But the base product unit cost is measured by width and height while the unit price of add-on is based on quantity.
Can I do that?
The quote will also show 2 prices depending on the choice of paint. For example
Option 1 plain paint = $50
Option 2 metallic paint = $100
These prices will vary depending on the customer type.