Alix Axel Alix Axel - 2 months ago 6x
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?

  • 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.