Answer the question
In order to leave comments, you need to log in
How to organize SQL table?
There is a table Employee (id, first name, last name) .
There is a table Working team . (id, date of formation, ...?)
The work team is formed daily, but the number of employees is not known in advance. I can’t figure out how to properly organize the Work Team
table so that at the time of formation it contains one record of the necessary workers?
The history of the formation of work teams must be kept.
The following solution is spinning in my head: Working team (id, date of formation, id_worker_1, ..., id_worker_N)
But there is a suspicion that this is nonsense.
Answer the question
In order to leave comments, you need to log in
This is really bullshit. Then one more table is required:
Composition of the team (id_work team, id_worker).
The working team will be a kind of heading, with a date, number and goals.
And the composition of the team will contain a list of workers who are included in a certain team at a certain moment.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question