Re: storing start/end times
Posted by: Peter Brawley
Date: April 16, 2015 08:38AM

> when you suggested the stores_open table...you included in it a d date column
> that will reference the calendar table.

> I do not understand why this column is needed?

Open & close times for that date. Joins to calendar tale on that date.

> When the user enters the open/close hours(for Monday for example)
> he is not requested to enter any date?

If you want to let the user set default open & close times for all Mondays, set up her input form that way, then propagate stores_open for all non-holiday Mondays with the result. And so on for other weekdays.

Options: ReplyQuote


Subject
Written By
Posted
Re: storing start/end times
April 16, 2015 08:38AM


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.