F
Filament•4mo ago
Mohammad Ali

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
🤖transistor🤖
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.
Mohammad Ali
Mohammad Ali•4mo ago
Thanks ... but no. Infact I need a table-less 'Date' model which I could make a resource based on