Well I am much interested in how you would change my database! If I
have understood you correctly this is what should be done:

recipes (no changes)

Add a new table that joins ingredients with raw materials.
recipes_ingredients (recipe_id, ingredient_id, raw_material_id)

ingredients (number result: e.g 400 - I will remove the raw_materials
foreign key from this table)
raw_materials (price and unit - maybe also a picture later on. Result:
e.g 100$, kg)

So how do I set up my recipe model?
recipes_ingredients belongs to recipe
ingredients belongs to recipes_ingredients
raw_materials belongs to recipes_ingredients
Could it all be defined in one model? I think I know how to do it with
the bake script. If so, will cakephp know how to show ingredients in
the recipes view? Or do I need to customize something first?

Best regards.
Asbjørn Morell.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---

Reply via email to