M
M
Meehalkoff2014-04-24 22:10:23
SQL
Meehalkoff, 2014-04-24 22:10:23

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

2 answer(s)
S
svd71, 2014-04-25
@Meehalkoff

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.

S
Sergey Nikolaevich, 2014-04-24
@Playmore

Work team.(id, employee id, formation date, ...?)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question