Laravel booking system design
I want to create a booking system in Laravel where user chooses Date and one of the timeslots given. My idea right now is to store in database table (MySQL), the booking_date in one field and the booking_timeslot in another. The problem with this design is that I do not know how to prevent another user from choosing the same date and timeslot, or how to render the timeslot chosen on a particular day non-usable again.
Please I would really appreciate any advice. Thank you in advance.