Table Structure

[energylevel]

Can SQLyog help me do this:

Database for sports team:

Have a fixtures table: unique id, home team, away team, team scores, venue etc

Have a players table: squad no, name, position, goals scored, assists

I want to add goal scorers and assists to each fixture and keep a running total that can be displayed for each player, i.e. total goals scored, total no of assists, should I be creating a separate table for each player?

Thanks

[peterlaursen]

i think you should not create a table for each player.  Only I suggest that you add a 'player ID' column (and also unique ID – Primary Key)  to the players table as well.   You may also create a teams table.  And finally maybe also consider if the table structure can handle if a players changes from one tam to another?

SQLyog can help you (easily) to create what tables you want.  But it cannot decide how the tables should be. 

[Author]

Posts