I am designing a new application to track sports statistics. I am using code first migration. I have the bare minimum POCO setup. The problem is I am not happy with the design specifically how the players, teams and tournaments are relating to each other.

This is my player account class

then this is the team class

Then I have the tournament class

On a tournament there are multiple instances of matches (games)

and of course we have multiple instances of match results in one match. The Score property determines who is the winner.

I have a multipart key that creates the relationship between a player an a team

And I have another like that for team and tournament

I am designing a new application to track sports statistics with code-first migration. I have the bare minimum POCO setup. The problem is that I am not happy with the design specifically how the players, teams and tournaments are relating to each other.

PlayerAccount class:

Team class:

Tournament class:

On a tournament there are multiple instances of matches (games):

And of course we have multiple instances of match results in one match. The Score property determines who is the winner.

I have a multipart key that creates the relationship between a player and a team:

And I have another like that for team and tournament:

I appreciate any comments and suggestions..

-Regards,

Ryan

I appreciate any comments and suggestions.