Re: storing start/end times
Posted by: Dimitris Papageorgiou
Date: April 28, 2015 10:40PM

Peter Brawley Wrote:
-------------------------------------------------------

> Eh? The user fills in default weekday values, but
> the app needs to figure out open/close hrs for
> every day of the year including holidays, weekends
> and special occasions.

Let me say i what is the plan.
The user fills open/close hours for every weekday and a separate table contains holiday dates.

There is no need for dates col in stores_open table since frontend code will cross-check the current date with the ones found in the holidays table and then the closed days will be "marked".

Do you understand what I am trying to do here?

Options: ReplyQuote


Subject
Written By
Posted
Re: storing start/end times
April 28, 2015 10:40PM


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.