in reply to OT: planning out mysql structure

What you're asking for is called "data modeling". It's a fairly broad subject. You may want to just start with Data Modeling 101 and then come back with specific questions once you have an initial framework in mind.