I am making project similiar to ZocDoc, where i would like to create a time slot system. so i need to a db structure for the system.
I have already designed a table for doctor and hospital, but i need to create a time slot system.
The doctor can create the schedule, he can choose his own days.(ie)
1. Working all the days
2. May be he work alternative days.
3. May be he work only on monday and friday.
Also he can his tie interval from morning 6am to evening 11 pm
Also he can choose the timings of half-an-hour for the patient, 1 hour etccc that depends upon the doctor
** Patient can book an appointment with the doctor.
I need only table structure. I am currently developing the program in zend framework.