I apologize if this is not the right venue to ask such a question. This is my first time on this site and I'm open to suggestions.
I am trying to find a good schema for a database that needs to record discrete timeslots of availability of a certain item (like an Airbnb room for example) and allows users to search for items that are available on a certain timeslot.
My current solution, on a NoSQL database, is to have a collection of items with certain parameters, of which one is an array of available timeslots.
Item 1 Name: Foo Location: Miami Available_Dates: [Tues 10am, Tues 11am, Wed 12pm, Wed 1pm....]
From this schema, I would search for items where
available_dates contain X or Y slot(s).
Since the potential available times can be quite a few per item, I'm not sure if my current solution is the optimal one. Is there a best practice for something like this, or a suggestion as to how I could structure my database?