MySQL Forums
Forum List  »  Database Design & Data Modelling

Advanced Search
New Topic

Re: separate table or no for days closed
Posted by: Peter Brawley
Date: May 06, 2021 11:04AM

What about holidays, other days the store closes for other reasons?

If a day or date is missing from `store_open`, the store's closed. Simple query, seems redundant to store it.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
separate table or no for days closed
Dimitris Papageorgiou
May 06, 2021 07:07AM
Re: separate table or no for days closed
Peter Brawley
May 06, 2021 11:04AM
Re: separate table or no for days closed
Dimitris Papageorgiou
May 08, 2021 10:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.