Storing properties of a clothing item
I am storing details for clothing items.
Currently each item has a gender, category, type and variation.
E.g item001, male, 4, 6, 3
4, 6 , 3 is a reference to the cats, types and variations table(s).
So 4 is Trousers, 6 is jeans, 3 is slim fit.
However now I want to store much more detail about each item.
So should i use the existing structure and add columns like variation 1, 2, 3 etc or just have one table with all the possible properties and have a itemHasProperties table with item id and property id