I would like to create a historical archive of the players. I would like to represent for every player with these attributes = first name, last name, date of birth, one or more roles [gk, dc, ts, att and others] and skills. each player has a career during which he plays in one or more teams with these attributes = name, nationality and id.
the player’s participation in the team is characterized by = goals, games played, goals conceded (applicable only to the goalkeeper). Each participation is characterized by one or more relevant periods with a start date and an end date.
enter image description here
I tried like this but I had doubts as to whether the constraint whereby a player cannot play in more than one club team in the same period but only at the same time for a club and a national teami try .Is it the wrong solution? Are there better representations?
dok is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.