I'm creating an application that stores product data in a (now) relational database. But a washing machine has different properties then a laptop fe. They both are a type of product, with always a price, title, desc and image, but only laptops have a harddisk (mostly)
So what to choose as a model?
- key=> value metatable with megajoins.
- everything in one table.
- create one product table and a joined table for each category.
- The unicorn quality solution I didn't know about.
I'm favouring option 3, but that still feels wrong and hard to scale and I'm unsure if I'm forgetting something or that my years of relational php / mysql thinking are steering me away from another and way better choice.