Resource table with date granularity
How can I have a table with all dates within a range?
Say I want to list room reservations by date and also want the list to contain dates without any reservation.
2 Replies
you seem to be looking for a db design, check this out (skip to the Hotels and rooms section) https://vertabelo.com/blog/a-database-model-for-a-hotel-reservation-booking-app-and-channel-manager/
no affiliation, just found it in my bookmarks
Vertabelo Data Modeler
A Database Model for a Hotel Reservation Booking App and Channel Ma...
Everybody books into a hotel at some point. In this article, we’ll look at a data model that could power a hotel reservations system and channel manager.
Thanks ... but no.
Infact I need a table-less 'Date' model which I could make a resource based on