video1.0<iframe src="https://www.loom.com/embed/44e3c1e6558d4cbe9e547bdc549110a8" frameborder="0" width="912" height="684" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>684912Loomhttps://www.loom.com684912https://cdn.loom.com/sessions/thumbnails/44e3c1e6558d4cbe9e547bdc549110a8-7f58847f5497523e.gif118.766667In this video, I present Oratime, a management system I developed for the fictional Glow and Radiance Spa, focusing on the co-booking flow and payment processes. I demonstrate how users can select available dates and times, and once payment is completed, the booking is confirmed and the slot is no longer available for others. To prevent double bookings, I've implemented a two-layer protection system: a backend slot reservation that temporarily locks the slot during payment, and a database-level unique constraint on staff, date, and time. Additionally, I use a partial filter to ensure that cancelled bookings do not block future reservations. Thank you for watching!