U
U
urajo2020-04-18 14:51:44
MySQL
urajo, 2020-04-18 14:51:44

How to implement a directory?

How to set up links and queries for the directory? Now there are 5 tables. Branches, floor, telephones, linking table of floors and branches, telephones and branches. I bring out all the departments, by pressing the floors are displayed. Now the question is how to break people down by floors, so that I would press the office, then the floor and display contacts only from this floor?
Phones
W-9pyk0zNtw.jpg
Departments
NtVYpWyNpno.jpg
Floors
x2PmM7T1PO0.jpg
Communication between floors and departments
r-eLUjfxyQE.jpg
Communication between phones and departments
Q3MuAwqJJ8s.jpg

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question