I have been working on a solution to manage conference call lines and their availability. I am looking to script a search that would show what lines are available for a certain day and time.
I am not set on any structure yet and would like to create something efficient with the ability to expand.
8 conference call codes scheduled for approximately 2 hrs. System needs to determine what codes are free at a specific time and assign that one. (Similar to a hotel booking, but in hours).
I was thinking a parent table of bookings and a child table of availability.