Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Database structure advice sought

View all replies to this thread

Database structure advice sought

Thread began 8/17/2014 8:57 am by Patrice | Last modified 8/18/2014 8:53 am by Patrice | 795 views | 2 replies

8/17/2014 8:57 amPatriceWebAssist

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:
Gender (M/F/U)
Size type (waist, chest, etc)
Measurements (30"-37")

Then the tables that join these three:
Women's
Women's Lengths
Men's
Men's Lengths

So Women's would include
womens_ID
gender_ID
size_type_ID
measurement_ID
womens_ ?? fuzzy here… Women's (name of group?)

Mens' -- repeat with
mens_ID etc.

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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.