lundi 23 mars 2015

How to structure SQLite database

I have some baseball data from the 2014 season and am not completely sure the best way to structure it in an SQLite database.


I have a table for each individual team, which holds records for summaries of individual games.


Then I also have player stats from each game, but am hesitant to make a table for each player in the league to hold the stats from each game. Using this method, I would have about 750 tables representing players each holding about 160 rows of data.


I am a complete beginner to sql but this seems bad to me. I was thinking an alternative could be to hold all individual games for all players in the same table and then have an id for each player?


What would be the best way of keeping this data?


Aucun commentaire:

Enregistrer un commentaire