title: Schedule Table Design
body: <p>I am working on doctor scheduler page requirement. The below is the screen for showing a usual weekdays schedule for a doctor. </p>
  
  <p><img src="https://i.stack.imgur.com/yHn9R.png" alt="enter image description here"></p>
  
  <ol>
  <li>The doctor may visit only few days on a week and only between a period of time</li>
  <li>A doctor may be on leave some day. They add that entry </li>
  </ol>
  
  <p>I need to design the database table to handle above scheduling.</p>
  
  <p>I have no idea how a database table can be designed for 7 days with hours and doctors mapped. </p>
  
  <p><strong>The most important thing is for a given week i should be able to check the doctor availability.</strong></p>
  
  <p>I created a <code>DoctorLeave</code> table below to handle only doctor leave days</p>
  
  <p><code>DoctorId</code>, <code>LeaveDate</code>, <code>Comment</code></p>
  
  <p>But, How do i design scheduler table? Any idea/suggestions pls</p>