title: DB Design for Schedule
body: <p>I'm creating a web application wherein users should be able to specify their weekly schedule. Here's my DB model for that:</p>
  
  <pre><code>id
  user_id
  day
  from
  to
  </code></pre>
  
  <p><code>day</code> is an enum of 0-6 (0 for Sunday, 1 for Monday, and so on). <code>from</code> and <code>to</code> represent minutes from midnight. So, 0 means midnight, 1 means 12:01am, 2 means 12:02am, etc.</p>
  
  <p>Is this a good design? Any potential problems with it?</p>
  
  <p>What if I wanted the ability to display more than a week? How would I handle that? Right now, I'm just displaying weekly work schedule, but it might be nice to be able to specify more.</p>