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.