I see we do the same assignment.
I guess it is up to your decision described in "General considerations".
Of course there bad and good decissions
For me that 3PM is a little bit complex.
In my assignment "date" field contains only YYYY/MM/DD and I do not care about HH:MM. For me a room is available for booking if "date" is today or tomorrow.
The only thing do not know yet is if I should give user possibility to see all records (historical+all future) depending on checkbox. It seems to be not needed and it would speed up data transfer.
Any idea? Good/bad decisions?
Tom