We need to centralize our ability to manage the various schedules that our banking centers keep since it is a manual nightmare right now. Do you see any obvious gaps in this?
A schedule is defined by a set of Days of the Week, open times and close times. A logical record may look like this:
service_location service_location_type day_of_week open_time close_time Main Street Branch Lobby Monday 8am 5pm Main Street Branch Lobby Tuesday 8am 5pm Main Street Branch Lobby Wednesday 8am 12pm
I want to be able to reuse Schedules but am worried something here is a a bit off.