Home Suggestions for Modeling Operating Hours
Reply: 0

Suggestions for Modeling Operating Hours

user593 Published in April 22, 2018, 3:04 am

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

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.302465 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO