How to design a reservation system for resources that user can book any time & day they select?
Currently, my application design only do booking for today. As:
I am using a JTable to populate a list of resources with details for user to view. It also indicate the block of time that other user had booked. I joined the workstation table, pc table, peripheral table, and timeslot table. When a user booking is successful it will insert the name of the user to the block of time booked in this timeslot table.
I do have a Reservation table where by it stores all the reservation details such as the date, time, the workstation reserved, user id etc.
However, I can't possibly create a timeslot table for the 365days. It didn't make sense. How is such system(reservation system) implemented for real/in the market?