One to Many relashionships for a restaurants website?

Posted by myaccount on Stack Overflow See other posts from Stack Overflow or by myaccount
Published on 2010-03-31T22:55:50Z Indexed on 2010/03/31 23:03 UTC
Read the original article Hit count: 314

Filed under:

Each restaurant has restaurant branches, each branch must determine which days of the week it opens, each of those days must determine (several) open_hour and close_hour thru that day.

I created one to many relationship using these tables: rest_names ---> rest_branches ---> open_days ---> open_hours

Am I going right this way? or there is another way to do this, maybe less complicated? And how the query will be like to get the hours of a restaurant on a specific day, say sunday?

© Stack Overflow or respective owner

Related posts about one-to-many