E
E
Evgeny Solomin2014-03-23 12:01:05
MySQL
Evgeny Solomin, 2014-03-23 12:01:05

How to design a database structure?

Good afternoon.
There was a problem with the development of the database structure.
The task comes from the organization of the maintenance service (further writing software for mobile platforms, desktop application)
Well, that is, I am doing one database for everything at once.
There are such tables: -
Application (id_of the application, address, description, cost, date, status open, status in progress, status closed)
- Employee (employee_id, full name)
- Client (Name, contact)
Please tell me how against the background of such simple tables organize the relationship, that the employee took the application and she is registered with him? He fulfilled it - she got into his status as closed.
Maybe I thought the structure wrong.
The first time I took up the design of the database. How to do it better here?

Answer the question

In order to leave comments, you need to log in

4 answer(s)
T
Timur Sergeevich, 2014-03-23
@MyAlesya

I'm not an expert) in the Employee table, add the application_id field, which is taken from the Application table)

M
Maxim Barabanov, 2015-07-30
@zelsky

It's most likely a browser issue. Mb he is not able to go to the 8000th port? try 1) go to this address from the third device
2) move it to the 80th port

Z
zelsky, 2015-07-30
@zelsky

I used the Maxthon browser on WP

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question