Hello all.
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_item
item_id
item_ref
item_materials
item_dscpn
item_image_url
cms_type
type_id
type_name
(entered data for cms_type)
1 Necklace
2 Bracelet
3 Earring
4 Ring
5 Charms
6 Brooch
cms_item_type(joining table for cms _item and cms_type)
item_id
type_id
Ok so, so far that makes sense to me.
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)
1 necklace
1 bracelet
1 earings
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?
