Now is to design a database that records such as meeting room application situation, application has a start time and end time, add a state was going to the meeting room, occupancy, which have not been occupied, but later find a meeting room even someone asked for, but at other times should still can apply for,
Problems come, I can apply for it when in a new start time and end time, appended to the database field behind, but I don't know how to check the query, mentally, ever bosses make, give some ideas

CodePudding user response:

Obviously need a head line to support, for eight hours a day, you in the conference room behind how much field can override these time?

CodePudding user response:

reference 1st floor stelf response:

obviously need a head line to support, for eight hours a day, you in the conference room behind how much field can override these time?

Bosses, what call line, because I think the meeting room information can display the apply meeting room how many, how should make duck

CodePudding user response:

Behind is not added to the database field, but in another table, with a number of data for the judgment

CodePudding user response:

Well has been done, as long as according to the meeting room id application form, it is good to check a list traversal, no longer need to conference room table to add time field, is a complex, I think this logic should be right??

CodePudding user response:

This should make the master-slave table, the main table is your conference room information, there are several conference rooms, there are a few records,
For example:
The main table (room)
Conference room code meeting room name
1
in room 1012
in room 1023 room 201
From the table (meeting room use information)
Conference room coding applicants start applying for end of the time for meeting room
Zhang SAN 2019-01-01 08:30:00 2019-01-01 09:30:00 1
1 bill 2019-01-01 14:30:00 2019-01-01 16:30:00
2 fifty and 2019-01-01 09:30:00 2019-01-01 15:30:00