I have a big question about database design. I have some products to keep their properties in database. But there is not a exact template of this products. Some could have 50 fields of property and some have 4 or 5 field of property. And by the time user could add new properties to any product or could delete some of the fields from a product. What could be the best solution.. here I got some but could not think which could be better.
1. Having a template table and store products templates here. By relating them to the real value table got the problem. You can see this will get many inner joins.
2. Hard code to the admin panel and give rights to user to create, alter table.
3. Insert xml as text field in to the database but this time sql still confusing.
Is there an other solution. The solution can be outof the relational database models. But I want to know which will be best.
not: the database will heavily used in the future.
thanks as now.