Re: storing start/end times
Peter Brawley Wrote:
-------------------------------------------------------
> > frontend code will cross-check
>
> You're still not getting it. Usually it's sounder
> practice to implement such rules in the database,
> because it's much simpler & safer to touch up a
> database than to touch up application code.
Ok then...let me try put things on a new perspective here and restate the the problem:
The user enters closing/open hours for all the weekdays-no dates entered...these
are stored in a stores_open table.
There is also a holiday table which keeps dates for holidays.
The main question is how the user's app will be updated automatically about holidays...
For example today is Monday...tomorrow is Tuesday and it is a holiday and that must be seen automatically to the user's app.
I am not mentioning anything about calendar table(ΥΕΤ) and the like so AS TO FOCUS BETTER TO OUR PROBLEM.
Subject
Written By
Posted
Re: storing start/end times
May 04, 2015 10:12AM
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.