title: MySQL database design for soccer odds
body: <p>As you know, soccer odds results/history had no end. I want to generate output like this. What is the best practise to design mysql database?</p>
  
  <p><a href="https://i.stack.imgur.com/dcu1u.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dcu1u.png" alt="enter image description here"></a></p>
  
  <p>This is what i got so far:</p>
  
  <p>Table:</p>
  
  <pre><code>league: id, league
  
  teams: id, team
  
  odds: id, league_id, date, hometeam_id, awayteam_id, ht, ft,
  crown_open_1, crown_open_x, crown_open_2, 
  crown_closed_1, crown_closed_x, crown_closed_2, bet365_open_1,....
  </code></pre>
  
  <p>I'm stuck at odds table. How to design for odds table with 1x2 data, open and closed? Or split the data with "|" in 2 column instead of 6?</p>
  
  <pre><code>column: crown_open: 1.82|3.35|4.90
  column: crown_closed: 2.07|3.05|4.10
  </code></pre>
  
  <p>I guess all this approach can achieve my goal, but what is the best practise for long term? Or any other options?</p>
  
  <p>Based on @Rickjames answer, is this correct? Each bookmarker/type has 3 rows, if 4 bookmarkers then 12 rows for each game. Am i right?</p>
  
  <p><a href="https://i.stack.imgur.com/etElN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/etElN.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/aenRF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aenRF.png" alt="enter image description here"></a></p>