I am looking for some advice in putting together the proper models and
relationships in my application. My concern revolves around the
requirement to have default prices, but allow them to be optionally
The application involves clients choosing from menus of various
dishes. Several menus are predefined and the client chooses the one
they want to use.
The models I've identified are Dish, Menu & Client. Menu has_many
dishes and Client has_one menu. Dishes have a name and a default
price. So far so good.
Now the puzzle: What's the best way to model the overriding of a
dish's price on a client by client basis? Clients are related to
dishes through menus, but menus are shared across clients.
I think I need another join table which stores dish_id, client_id and
price. But then how to describe the relationship to rails?
Thanks for any advice on this.