title: SQL Database Design Many to Many
body: <p>I am creating a database based on a sporting game to store matches and each player involved in each match.  I am having trouble resolving a many to many relationship.  I currently have the following tables:</p>
  
  <p><strong>Player</strong></p>
  
  <pre><code>id
  name
  </code></pre>
  
  <p><strong>Match</strong></p>
  
  <pre><code>id
  date
  </code></pre>
  
  <p><strong>PlayerMatch</strong></p>
  
  <pre><code>player_id
  match_id
  home_team
  goals_for
  goals_against
  </code></pre>
  
  <p>There will always be a minimum of two players in a match.  Is this the best design for this approach?  </p>