How to implement a directory?

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

Departments

Floors

Communication between floors and departments

Communication between phones and departments

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

R

Rooly2021-03-23 11:40:40

How to properly organize apiResource Laravel? 2Reply

L

lutokris2021-03-25 14:12:22

Why does memory allocation for a string look out of pattern? 4Reply

A

Anholle2019-09-09 11:37:42

How to set up a filter in the feedback form? 0Reply

S

Sergey Valitov2015-12-27 18:55:58

How to make a selection by the latest date? 1Reply

I

id56346gera2018-05-07 18:44:37

SQL Is it possible to specify in the query, so that I can get all the employees who have less than 14 days left before the start of the vacation date before today's date? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question