Food recipes data formats

Food recipes

Recipe data to specify the ingredients of foods. Can be used to specify multiple ingredients (e.g., of apple pie), or to specify the amount of a primary ingredient needed to obtain 100g of the food (e.g. grapes to raisins). Recipe data can be used recursively (e.g., apple pie contains apple and flour, flour contains wheat).

Recipes

Table aliases: FoodTranslations, FoodTranslation, FoodCompositions, FoodComposition, RawFoodTranslations.

Table 29 Table definition for FoodTranslations.
Name Type Description Aliases Required

idFromFood

AlphaNumeric(50)

The code of the composite food (from-code), i.e., the code of the food for which the ingredient(s) are specified.

idFromFood, FromFoodId, FromFood, FoodFrom, Food

Yes

idToFood

AlphaNumeric(50)

The code of the ingredient food (to-code).

idToFood, ToFoodId, ToFood, FoodTo, Ingredient

Yes

Proportion

Numeric

Proportion of each ingredient in the food (%).

Proportion, Proportion%

Yes

idPopulation

AlphaNumeric(50)

Unique identification code of the population.

IdPopulation, PopulationId

No