I am a amateur with limited experience and I am building a web administration module for an online sports game. This is a not for profit program to assist with managine a National Team. At the moment I have a single table MySQL database with all the player details that are updated via a API.
I would like to track to players and their development. Players have fixed stats and also have variable stats that change a few times a week.
My initial design is to have two tables one for fixed and one for variable data.
Table 1 - Player (Fixed Data)
Fields
Player ID - Primary Key (unique number)
First name
Last Name
Height
Weight
Nationality
Table 2 - Player Stats (Variable)
Fields
Player ID - Primary/Foreign key
Date (submission of data)
Team
Form
Energy
Skill rating
The aim would be that I have record of a players development so does this design make sence?
Secondly can I have the Player ID as primary key which is a unique number in both tables?
Thanks