title: Database Modeling of a Softball League
body: <p>I am modeling a database for use in a softball league website. I'm not that experienced in DB Modeling, and I'm having a hard time with a question about the future.</p>
  
  <p>Right now I have the following tables:</p>
  
  <p>players table (player_id, name, gender, email, team_id)</p>
  
  <p>teams table (team_id, name, captain[player_id], logo, wins_Regular_season, losses_regular_season)</p>
  
  <p>regular_season table (game_id, week, date, home[team_id], away[team_id], home_score, away_score, rain_date)</p>
  
  <p>playoff table (pgame_id, date, home[team_id], away[team_id], home_score, away_score, winnerTo[pgame_id], loserTo[pgame_id])</p>
  
  <p>To make the data persist from season to season, but to also have an easy way to access the data should I:</p>
  
  <p>A) include a year column in the tables and then filter my queries by year?
  B) create new tables every year?
  C) Do something else that makes more sense but that I can't think of.</p>