I want to create a beauty salon shift system and look for a database structure. I want to create a beauty salon shift system and look for a database structure. 1: store the information of all beauticians in the database. 2. after selecting a beautician, the guest obtains the shift information of the beautician from Monday to Friday. 3: beauticians may work from AM to am on Monday, or from AM to am on Monday, not necessarily at a fixed point 3 every day: the guest chooses the beautician to create a beauty salon shift system for a certain period of time, and asks for a database structure.
I want to create a beauty salon shift system and look for a database structure.
1: store information of all beauticians in the database.
2: After selecting a beautician, the guest obtains the shift information of the beautician from Monday to Friday.
3: beauticians may work from AM to am on Monday, or from AM to am on Monday, not necessarily every day.
3: After the guest chooses the beautician for a certain period of time, other guests should not see the time period of the beautician.
Find a good database structure and algorithm
------ Solution --------------------
Reply to get points. By the way, borrow the first floor of the moderator and send a help Post !;;
The problem is as follows:
Why is the local test normal when I use php to send emails?
It cannot be sent to a foreign server.
Always failed to send
You don't need to modify this information.
All sent messages are accepted.
If ($ smtp-> sendmail ($ smtpemailto, $ smtpusermail, $ mailsubject, $ mailbody, $ mailtype) = "1 "){
Echo "email sent successfully! ";
} Else {
Echo "failed to send email! ";
}
That is, it always fails.
------ Solution --------------------
Without detailed requirements, it is difficult for others to list them for you.
For example, do you want a beautician's name? Gender or not, age or not? Is it just a number? Or "art name "?
Does each beautician have specialized services? For example, if A does not dye hair, B does not do A normal haircut?
Different services should take different time. what do you do?
What time does the shift schedule start from? Accurate? Or half an hour?
Is there a gap between each service segment? (Should a beautician go to the toilet and do other preparation work ?)
How can I cancel an appointment?
.....
.....
If I took over the project, I wouldn't start designing it without asking all the requirements.
Because these questions are answered differently, the data to be saved will be very different.
Discussion
Can I list the shift table structure in detail?