I have a table of deks
As you can see, I try to know if the user have a booking for today or tomorrow.
I used a rollup that can return me the latest booking so if a user book just for today (and have the previous booking) that’s fine. But if a user book for tomorrow, I’m screwed.
Any idea of how I could have a boolean for is_seated_today and is_seated_tomorrow?
Bonus question: if I can get them today and tomorrow booking details (like with a relation) it would be even better.