I have these tables:
First table(Recipe table),
Recipe
recipeid(PK,AI)
recipename
ingredients
Second table(Ingredients table),
Ingredients
ingredientid(PK,AI)
ingredientname
quantity
Then a 3rd one for display,
Recipe_ingredients
recipeid(FK)
ingredientid(FK)
quantity
How do i construct another table and its relation to the ingredient table to determine its nutritional value.
Should i add another column for nutrition on my ingredient table? Or create another table for nutrition which holds the ingredient id as FK.
Nutrition
Ingredientid(FK)
Say i am diabetic so i should avoid recipes with high amounts of sugar. So from ingredients... im confused where to move from there.
Recipe
&Ingredient
orRecipes
&Ingredients
. The first option is better.