sport league database help

[debecc]

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

[fenway]

I do think that you'd have to put home & away for each game record.