On 19 Oct, 13:54, h...@laterooms.com wrote:
> Hello,
>
> I've been designing a schema for a web app that will allow users to
> create a weekly meal plan and shopping list.
>
> At the heart of the design is the model for recipe data.
>
> I currently have a hierarchy of:
>
> Menu eg. Mozzarella Salad, Beef Casserole , Apple Flan w. Raspberry
> cream.
> Meal eg. Apple Flan w. raspberry cream
> Dish eg Apple Flan
> Recipe - eg pastry case, apple sauce, topping
> Ingredient - eg flour
>
> At the lowest level - ingredient, I also have:
>
> Measurement
> Method
> Equipment tables
>
> My question is, how do I connect these tables? I've created an
> 'ingredient list' table, which links the ingredient, measurement and
> recipe tables and contains:
> recipe ID
> Quantity
> Measurement ID
> Ingredient ID
>
> Do I need to create list tables to link every other set of tables up
> the hierarchy?
> How do other systems deal with hierarchies?
> Can you ?
>
> Thanks you for your .
>
> Hugo
http://del.icio.us/Captain_Paralytic/hierarchical