Home Suggestions for Modeling Operating Hours
 I need to model a table, and relationship that represents the following: The hours of operation of a company. My initial idea is, 1 Company - N business hours. That's because depending on the day, the timetable may vary. Example: On Saturdays the company works until 12:00 PM. And from Monday to Friday, it works until 6:00 PM. Do you understand? These are things that vary and I need to have this in a table. It's confusing for me, what fields do I put to answer the following question: Which companies are open now? My database is mysql