Creating a Daily Schedule
As a volunteer I am working on a solution for our local community access TV station. The next step is a module that staff can use to schedule studio time. Each day will have 15 minute slots from 8 AM to 10 PM. Users will select a number of contiguous slots and then enter info on who has reserved the time.
I am thinking a creating a database with each 15 minute time slots as a separate record. These records would be created only as the time slots are scheduled.
I still have a lot to work out for this problem. I don't want to reinvent the wheel if there is a free model I could look at or incorporate.
Thanks for any suggestions or ideas.
One record for each time slot sounds like the correct approach.