Questioning my normalisation

[Weedpacket]

NogDog Like I said, though, I don't feel strongly about that since the number of days in a week are not likely to change

I can't think of any shops that schedule their opening hours on a cycle of anything other than a week.

It will though make it a bit fiddly to ask day-relative questions like "is the store open right now?" or "what time does it close tomorrow?" since you can't parameterise the name of the column to query. Mind you, you'd still need to figure out what day to search under anyway.

[cluelessPHP]

NogDog enum

I didn't know that was a thing

[laserlight]

For generic "shops", I'd say that there's a pretty good reason to separate the daily opening hours by week into another table: some shops are restaurants that open for lunch, close during the afternoon, then re-open for dinner. Your original design where you assumed that shops open once a day cannot model that.

On the other hand, I don't think it is useful to separate the opening and closing times into different rows. I would see "shop_hours" as modeling time periods denoted by the opening and closing times, rather than a particular "shop opening/closing time", which is what NogDog's design looks like.

[NogDog]

laserlight I would see "shop_hours" as modeling time periods denoted by the opening and closing times

I might go with that -- just had an urge to separate it out from the shop table. 🙂

[Weedpacket]

Note that a shop's opening hours may span midnight; that would involve either notionally "closing" the shop at midnight and then immediately "reopening" it, leading to a situation similar to laserlight's; or keeping the interval between opening and closing contiguous and refuting the idea that a shop's opening and closing hours are on the same day.

Shops that are open around the clock, of course, are free to close-and-immediately-reopen at whatever time of day suits their processes.

[dalecosp]

When do they close on Tuesday?

[cluelessPHP]

Never, they are forced to work 24 hours 😉

[dalecosp]

cluelessPHP

Sounds like my last project deployment ... 🙄

[cluelessPHP]

dalecosp
I'm sure your bosses made sure to pay lip service to your dedication 🙂

[dalecosp]

I even got a paycheck.

For the same $$ as usual, of course.

https://youtu.be/3obteqT0VJU?t=167

[cluelessPHP]

dalecosp
Pay checks? It's a bit weird, if you're not getting a brown envelope behind the bar something is wrong