How to store store opening hours and determine which ones are open?

L

L

Lexxtor2014-09-04 23:34:38

Database design

Lexxtor, 2014-09-04 23:34:38

How to store store opening hours and determine which ones are open?

The database has a table for stores.
It is necessary to do as in 2GIS:
The graph is displayed in a convenient form.
You can apply the "open" filter - only open stores are displayed.
So far, the option with the period table comes to mind:

store_id
week_day
time_open
time_close

but this is obtained for each store 14 entries, if there is 1 break during the day and the opening hours are not the same every day.
Maybe some other way?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

N

netrox2017-05-08 10:32:53

How can I make this slider? 5Reply

R

R000M2015-05-26 13:08:15

Why won't Thunderbird and Outlook recognize WoSign's SSL certificate? 2Reply

N

nameOfUser 1232017-06-20 13:57:33

How to combine 2 languages C++ and C#? 3Reply

A

alekseyizmaylov2019-04-23 21:03:41

Building codes and databases, how easier to implement? 2Reply

E

Eternal972021-01-18 20:54:18

How to design a database for a checklist service? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question