Re: adding another criterion (the schedule)
Posted by: Peter Brawley
Date: November 24, 2015 10:22AM

1. `day` is probably best saved as tinyint, 1...7 or 0...6, whichever is more convenient.

2. `open_time_b`: Yikes. when you find yourself writing column names like xxxx_1a,b,c etx, remind yourself that you're denormalising and you'll pay for it big time later, eg what'll you do for the store that has three open periods on Fridays?, eg you'll have lots of nulls to handle for one-period-per-day stores in queries. Don't define tables around arbitrary assumptions that reality can easilybreak, use a child table of open/close times.

Options: ReplyQuote


Subject
Written By
Posted
Re: adding another criterion (the schedule)
November 24, 2015 10:22AM


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.