Alix Axel Alix Axel - 1 year ago 129
SQL Question

Fixed Timetable DB Design

I want to let my users specify which hours / days they want to be contacted, I though of creating a fixed timetable with the 7 days of the week and let the user specify which hours he has free.

I'm having a little trouble figuring out how I would store that info in the database, can anyone help me with a good table design for this situation?

Answer Source
  • The Day table contains list of days (Sun, Mon, Tue..), you can also use enumerated field instead.
  • The Period table contains list of available (hourly) periods, or you could also use part of a day.


Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download