Team - team_id(pk), team_name, team_logo(this would be a path to an image), year formed, years in league, active(Boolean),
Player - player_id(pk), team_id(fk), player_name, p_height, p_weight, year_league,
positon - position_id(pk), player_id, positon_name (did this bc there could be more than one position)
Now, where I'm struggling is doing the scores. I want this to be legit. I want to do weekly scores and total scores.
I have though of several ways.
week 1 - team_id, team_1_score, team_id, team_2_score I didn't really like this way.
team 1 scores, team_id, week_21_2011, week_02_2011,....,week_10_2001 (same for every team.)
I want to be able to go back to previous seasons and add in scores for other teams in past years (why I put 2011) I will need to be able to make bye weeks for team and, also, some teams will make it to play offs and championship game.
If someone can just point me in the right direction, that would be great.
If you want to look at all the numbers, the website is www.mtflonline.com
thanks in advance,