How is the control scheme implemented?

Question

MySQL

The table will contain: team, team characteristics:
members who are in the team,
members who were in the team,
names,
number of hours worked for yesterday, the day before yesterday and so on until day 30,
how much they worked in a month,
statistics on the implementation of the norm
I have a few ideas :
1) Make a column, put json with this data about the clan in it
2) Make a table "Team", "Participants" and link it as 1 to many, but here the downside is that the database will contain data about many teams and participants will be typed there with at least half a thousand participants.
How are such tables implemented in general?

Answer 1

Three tables are better: teams, participants, hours worked. In the table with hours, store the hours worked by the participant on the date