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
one-to-many
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