Here is what I plan to do:
I have a list of restaurants and I want the user to be able to query the restaurants by searching a specific time slot that a restaurant is open. For example, the app can return all the restaurants that open after 10 p.m. on Thursday or open on Sundays.
What is the right way to do the database design so that I can accomplish the goal? Thanks.