Answer the question
In order to leave comments, you need to log in
Yii2 - how to structure the database correctly?
Hello, please help with advice on how to correctly connect the tables according to logic?
1. There is a table - a list of offices (Head office and branches)
2. Table of departments. (The list of departments changes according to one or another office)
3. Table of departments. (The list changes according to one or another department)
4. Table of positions. (The list changes according to a particular department).
And there is a table of the workers themselves, where the relationship with all the tables above takes place. (Dismissal, appointment to another position, etc.). Can you please tell me how to store these links? Thanks in advance to all who respond.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question