title: How to go about building a daily timeslot with php and mysql?
body: <p>I am currently working on a project where i was required to develop a timeslot system where employee can occupy a time slot within a specific day. I am using military time as my time format 00:00:00 - 23:00:00 and the days are from sunday - saturday. I just want them to book times for each day.</p>
  
  <p>what is the correct mysql schema for this?
  How do i go about handling validation, making sure that they only book for the available timeslots. </p>
  
  <pre><code>   ----------------------------------------------------
      USER_ID   |   DAY    |    STARTS_AT   |     ENDS_AT
      ----------------------------------------------------
                |          |                |          
                |          |                |       
                |          |                |       
                |          |                |       
                |          |                |       
     ------------------------------------------------------
  </code></pre>