I have these tables:
First table(Recipe table),
Second table(Ingredients table),
Then a 3rd one for display,
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.
Say i am diabetic so i should avoid recipes with high amounts of sugar. So from ingredients... im confused where to move from there.