[Help] Session Based Booking, DB and Logic?

Thanks in advance.

Currently have a small project for a KTV (nightclub)
let say they have room with 3 session(per day) for booking. ( each session 4 hours )

I still not sure how to design this effectively, Especially the filter logic when user search avalability, also how do i create reservation database?

Example
User A book Room 42 , 28/2/2022 - session 1&2

You can do it several ways. But first for basic understanding and to develop a rough structure this manual will help you.

Once you develop a rough/draft one you can share here. You will get the help surely.

This topic was automatically closed after 70 days. New replies are no longer allowed.