Relations with multiple fields and references, or with constraints.
Lets say I have a table
The food table contains an
The nutrient table contains an
I want to create a many-to-many relation about the food to their nutrients, so I did a third table:
The food-nutrient table as a
This setup seems to be doable with the many-to-many example, I did it just fine...
I can now query
NOW, lets say, I want
Is it doable and how?
In MySQL, I would do this with a join (like the following) but I would rather use a relation if possible:
I saw that relation accept arrays in
foodnutrientThe food table contains an
idnameThe nutrient table contains an
idtypenameI want to create a many-to-many relation about the food to their nutrients, so I did a third table:
food-nutrientThe food-nutrient table as a
foodIdnutrientIdamountThis setup seems to be doable with the many-to-many example, I did it just fine...
I can now query
food.foodNutrientsfood.foodNutrients[number].nutrientNOW, lets say, I want
food.macrosfood.microsnutrient.typeIs it doable and how?
In MySQL, I would do this with a join (like the following) but I would rather use a relation if possible:
I saw that relation accept arrays in
onefieldsreferenceswhere