I must make a table with dentist office hours. I am going to link this to the "dentists" table so you can see their respective hours of operation for when a patient requests an appointment and see which ones are available. So far I only have the fields for days (1 Monday, 2 Tuesday, etc) , dentist_id, time_from and time_until. What other fields are needed in this office hours table?
Thank you very much in advance for the help.
You should take into account that the schedule can vary over time so you have to take into account the day/month/year apart from the start and end times, the dentist_id and probably to which patient the shift belongs . You can do the days of the week but it has to be an external field or just text