I'm focusing on a web-based jewellery store website. Among the demands is the fact that in the back finish oneOrcolours could be selected for any single bit of jewellery to ensure that customers would have the ability to sort/view only products which are for example eco-friendly.
What's the easiest method to store this inside a database? If this is completed with 3 tables:
- product table (already is available)
- color table : each area includes a color
- table that suits the merchandise is by using the colour id
Is the right way to get it done? I'm using php and mysql however i think case quite a standard database question.
Yes, your solution having a many-to-many relationship between tables sounds great for your situation. After that you can easily JOIN the tables to obtain information from the IDs.
Yes, that's a suitable method of doing it.