title: Doctor scheduling database design
body: <p>I got this below user interface for scheduling functionality.</p>
  
  <p><img src="https://i.stack.imgur.com/ILCAx.png" alt="enter image description here"></p>
  
  <p>I need to setup the doctors available time for some days for each week of the month.</p>
  
  <p>How should i create the table for handling this.</p>
  
  <p>I thought i can create a <code>table structure</code> with the below columns</p>
  
  <ol>
  <li>DoctorId</li>
  <li>Date</li>
  <li>AvalableFrom</li>
  <li>AvalilableTo</li>
  </ol>
  
  <p>But here the problem is I will be adding 2 rows for the same doctor if he visit two different timings in same day. </p>
  
  <p>Is there any issue in my database schema or any better table design will help me to do this simple?</p>
  
  <p><strong><em>With this table i should be able to detect a doctor is available or not for the particular day and time</em></strong></p>
  
  <p>How best i can improve my table design?</p>
  
  <p><strong>Edit:</strong> The screen which i am working is, to help the <code>Hospital Staff to know when the visiting doctor is available</code>, so they can book the appointment for the patient for a time or inform other available time</p>