I have built an app booking meeting follow slot and it is database structure and relationship in database
meeting 1-n rooms.
meeting n-1 slots.
its app require me validate time like if a person create meeting at room 1 at 6:00am to 8:00am then no one can book the meeting in the interval in 6:00am to 8:00am. But I have a trouble with the relationships in database:
I want to create the meeting and check if the start time is available with all meeting in the room then link to the modal. I can access to the start time of the New Meeting
but when I access to the time of the meeting in the current rooms it have the infinite loop and I can’t access to the datetime of the all meeting to validate.
Could you tell me the reason cause this problem and how I solve it. Thank you