Hi Pete, I have done exactly what you are working on, for a catering company that takes orders over the web. I had a different challenge as they change their menu every week, do deliveries etc. Although you say it is not for commerce, once your client sees how nifty everything works, they will probably want to be able to take orders. This is what happened in my case. So you might want to prepare for that to some degree and consider adding Orders and Orderitems tables to your schema as well, or at least sort of keep it in mind for the future. Looks like you have it well under control though.
-- Josh ----- Original Message ----- From: "Pete Ruckelshaus" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Friday, June 09, 2006 7:21 AM Subject: Re: RFC on my tentative database schema for a restaurant menu database > Jim, that's a good suggestion, also allows a restaurant to offer > essentially > the same item at different prices for lunch and dinner. Thanks! > > Pete > > > On 6/9/06, Jim Wright <[EMAIL PROTECTED]> wrote: >> >> Pete, >> No direct restaurant menu experience here...but I did note one >> thing...you may want to have the price at the tblMenuLookup level....I >> can see cases where a restaurant wants to prep a new menu (inactive) >> while another one is active...it may have some of the same items, but >> they may be raising or lowering the prices...rather than duplicating >> the item with a new price, you could tie it to the specific menu. >> -jim >> >> -- >> Jim Wright >> Wright Business Solutions >> [EMAIL PROTECTED] >> 919-417-2257 >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243052 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
