Hello guys. I'm trying to make a database about football games (results, managers, players etc.). For my Players table i want to include these stats:
- first and last names, nationality, date of birth (constants through time)
- games played the current season, goals scored, cards received, minutes played in games and some more (updated regularly)
I set a column ID with unique number as a primary key. My question is should i put all these columns in one table or i can split them in 2 tables - one for the constant data which wont change with time and 2nd with the stats which will change through time and updating regularly and use ID relation between them? Thanks in advance.