dynamic21 Posted January 4, 2008 Share Posted January 4, 2008 Hi guys, I'm using MySQL 5, and I just needed an idea of how to structure my database. I'm quite a noob to this, however I do know some basics. I need to keep track of users and their previous achievements. So, lets say, I have a table of users who run track. In this table contains their names, addresses, and 40-yard dash times. Now, I'm stuck on the idea of keeping track of a list of each individual's previous accomplishments. For example, I'd like to keep in the database that User-1 has won tournaments in City1, City2, and City3, while User-2 has won tournaments in only City3 and City4. How do I go about storing this "list" for each user? I'm sorry if my question has been answered before, I've been searching the internet for the past two hours and I just don't think I'm wording my question correctly in google or something. Am I making this much more complicated than it should be? Quote Link to comment Share on other sites More sharing options...
revraz Posted January 4, 2008 Share Posted January 4, 2008 Maybe have a table called tournaments id | location | userwon Where id is tournament id, location is the city name, userwon is the id who won it. Quote Link to comment Share on other sites More sharing options...
dynamic21 Posted January 5, 2008 Author Share Posted January 5, 2008 Ah yes, thank you! I thought of that solution as well, but I was concerned there might be a more efficient way of solving the problem. Thanks again, very much appreciated. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.