Re: storing start/end times
Posted by: Dimitris Papageorgiou
Date: April 20, 2015 08:12AM

I want to make one last question(I hope) though...as I said there will be a stores_open table with columns for open/close time and another column for the day.

regarding the day column...it will be VARCHAR type so the weekdays are stored in it.

How do you see the above structure?
There is the alternative that a separate table holds the weekdays and is referenced from the stores_open table weekday column.

What do you think?

I think the first option is better.

Options: ReplyQuote


Subject
Written By
Posted
Re: storing start/end times
April 20, 2015 08: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.