I am building out an appointment scheduler application. I am seeking advice on how best to tackle this issue.

I am building out my ERD and I am the point where I will be creating a appointment_slots config table. In this table, I need to have a list of all my site locations (their IDs), a reference to the service name/id, and the part I am a bit confused on is how to setup the time intervals for each service during a given start and end times for appointments.

For example, all my stores will have 6 services and each service will have n amount of slots available to book in a given half hour period.

Would the design of the table look as follows?

-storeid -serviceid -halfhr1 -halfhr2 -nth half hour (where half hour is a representation of 7am - 5PM.)

Let me know your thoughts and I appreciate your wisdom and help in advance.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.