How to handle calendar in database

Question

Hello,

I am doing a personal project, to practice programming and I came across a situation that I am struggling to resolve. A user has a routine that repeats weekly, where each day of the week he has different free time, for example:

Monday he has from 17 to 20h free, already Tuesday has from 8 to 14h, and so goes until Sunday, but next Monday he has the same free time, from 17 to 20h free.

What is the best method of storing these free time hours in a database MySQL. In order to be efficient and occupy as little space as possible?

Answer 1

Table: Horarioslivre

id*   |usuario_id  |  dow   |   hora_inicial   |   hora_final
 1         1           2             17                20
 2         1           3             08                14

where, usuario_id is fk for table of usuarios, and dow is the 'day of week' that is, day of the week, being Sunday = 1, and Saturday = 7.

see more about the mysql function, DayOfWeek():http://www.w3resource.com/mysql/date-and-time-functions/mysql-dayofweek-function.php