help me on calendar and time scheduling?

[phpmady]

Hi Guys,

 

I have a project where i have to do a patient doctor appointment, i have build a db with table with patient and doctor, but i am not sure about the tables or date and time scheduling for appointment?

 

Each and every doctor has their own dates and timing,plz give me some tips in building these.

 

Thanks

 

 

[Muddy_Funster]

IMO you would do better with an individual table for each doctor, as well as a control table that holds the particulars of that practitioner.  That would then make things much easier

[phpmady]

IMO you would do better with an individual table for each doctor, as well as a control table that holds the particulars of that practitioner.  That would then make things much easier

 

Hi,

Thanks for your reply, you mean  1000 tables for 1000 doctors

[dragon_sa]

I have done a similar project with staff appointments, I setup a staff table and included the days of the week in that table for each staff member, for each day of the week I listed the times the staff member is available for appointments, I also had a check column to called onleave which showed if the staff member was currently working.

 

I then stored the appointments in an appointment table, which contained the appointment details the clientID and the staffID.

 

I also had a services table which held the service information and the time it took to perform each service, which is used to display the available times for a service or group of services depending on what the client selected on any particular day.

 

I used a calander function which then checked the staff table for available times for each staff member and displayed the times. I set out the schedule in 15min increments and a client can select the 15min start block they wanted from the available times.

[phpmady]

I have done a similar project with staff appointments, I setup a staff table and included the days of the week in that table for each staff member, for each day of the week I listed the times the staff member is available for appointments, I also had a check column to called onleave which showed if the staff member was currently working.

 

I then stored the appointments in an appointment table, which contained the appointment details the clientID and the staffID.

 

I also had a services table which held the service information and the time it took to perform each service, which is used to display the available times for a service or group of services depending on what the client selected on any particular day.

 

I used a calander function which then checked the staff table for available times for each staff member and displayed the times. I set out the schedule in 15min increments and a client can select the 15min start block they wanted from the available times.

 

Thanks  dragon_sa  you for sharing your project, i got some input from them