we are making a scheduler using php. I will explain the execution process with example. If the consultant have these times available.“1:00-2:30, 3:00 -5:00, 6:00-9:00, and 10:-11:45 to make appointment. when a client schedule a 15 minute or a 30 minute appointment then automatically five minutes will be blocked before and after the appointment depending on if there was available time before and after the appointment fixed by the client. When the client schedules a 1 hour appointment there will be a 10 minute block. If client makes an 30 minutes appointment 3:30-4:00, then the new availability time will be 3:00 -3:25, 4:05 - 5:00. so we will get available time 3.00 to 5.00 is separated into two such 3.00 to 3.25 and 4.05 to 5.00. We have the maximum of 72 available timings per day for each consultant . For each available time we will have two available time when the appointment is fixed in between. Now how could I make a table for this kind of situation to store timing and is there any other way to work around this??