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.
In Section
Seekers of Perl Wisdom