debecc Posted March 23, 2007 Share Posted March 23, 2007 Hi, I don't know if this is the correct forum for this question. I am sorry if it is not. I am relatively new to database design and mysql. I am trying to build a database for a local softball league. I want to be able to output a schedule for each team, standings , and game results. I am trying to figure out the best tables to create and what to populate with. At the moment my biggest question is for the schedule or games_table. If i have a teams_table would you add both teams as a column to the games_table? For example home_team and away_team? Or just have one team column and then there would be 2 records almost identical except for the team? I think i've been thinking too much about it and I've gotten myself confused. I am planning on a winners_table,losers_table and scores_tables. These I thought I could use to make joins to get team standings and game results? Am I overdoing this. I just wanted to bounce off of some people who know what they are doing. Thanks for any help!! Deb Quote Link to comment Share on other sites More sharing options...
fenway Posted March 23, 2007 Share Posted March 23, 2007 I do think that you'd have to put home & away for each game record. 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.