Database structure advice sought
For all the mysql gurus who may have time to look at this, most appreciated.
I need to build tables/records to cover a number of contingencies and I'm trying to get my brain wrapped around it. I've attached a screenshot of what the client wants as the end result (currently being served as a pdf).
Tables that I assume I'll need:
Size type (waist, chest, etc)
Then the tables that join these three:
So Women's would include
womens_ ?? fuzzy here… Women's (name of group?)
Mens' -- repeat with
Does this make sense? Or am I missing something. And I'm not sure yet how I can lay it out on the page to match up the grid currently being used.
Any pointers most appreciated.