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