title: Multiple table database design
body: <p>I have a website where I display a list of sports players and their stats. Users can register and create a team of these players where I sum and analyze the team stats. I would like to give each user the ability to "cross out" a player from the list (yet not remove them from the database) and reinstate a player that has been crossed out back to the list if they need to. The players that are crossed out or not crossed out need to be saved in a database so when the user returns to the site their list is saved. </p>
  
  <p>These are the tables I currently have:</p>
  
  <pre><code>Players Table (COLS: Name, Team, Position, Stats, etc.)
  Users Table (COLS: User ID, Name, Email, etc.)
  Teams Table (COlS: User ID, 1, 2, 3, etc.)
  </code></pre>
  
  <p>I'm pretty sure that there is a better way to store the info in the Teams Table where I have a column for user id and then 30 columns (numbered 1-30) where I store the player name and position he was selected for in the cell (in this format Player Name/Position). A team can consist up to 30 players.</p>
  
  <p>I think I would need an "Available Table" that stores which players are crossed out by which users. I'm not sure what is the best way to go about this considering a user can cross out up to 600 players from the list.</p>
  
  <p>Any suggestions would be greatly appreciated, I'm completely new to dealing with databases and I have seem to hit a wall.</p>
  
  <p>Thanks!</p>