I'm designing a Relational Database for a jewellery designer.
This is what i've got so far.
(Sorry no diagrams yet i'm still thinking about the correct way)
cms_typeCode:item_id item_ref item_materials item_dscpn item_image_url
(entered data for cms_type)Code:type_id type_name
cms_item_type(joining table for cms _item and cms_type)
Ok so, so far that makes sense to me.Code:item_id type_id
Now comes a part that i can't seem to work out with my non logical brain.
I need to put some of the items into sets
So a set might have in it(only one of each item can be included in the set)
What would be the best way to join the sets up in the database?
Would it be adding another field into cms_items that you add a number into thats unique to the group set.
for example if you have a necklace and its in a set with an earing they would both have a set number say 1
Or would it be having a table that you would have all the items ids in?