I
I
Izzet_F2016-09-05 17:04:41
Yii
Izzet_F, 2016-09-05 17:04:41

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

1 answer(s)
A
Alexey, 2016-09-06
@Izzet_F

The simplest option
6265d2d6223b4a3cb9c6c0d5b2fabb92.JPG

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question