meal_foods

14 rows where food_id = 26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: servings

id ▼ meal_id food_id servings
32 19 19 Monster Bad Apple (16 oz can) 26 0.5
33 20 20 Monster Bad Apple (16 oz can) 26 0.5
43 23 23 Monster Bad Apple (16 oz can) 26 1.0
86 47 47 Monster Bad Apple (16 oz can) 26 0.5
89 48 48 Monster Bad Apple (16 oz can) 26 0.5
113 60 60 Monster Bad Apple (16 oz can) 26 0.5
118 61 61 Monster Bad Apple (16 oz can) 26 0.5
123 63 63 Monster Bad Apple (16 oz can) 26 1.0
151 80 80 Monster Bad Apple (16 oz can) 26 1.0
184 102 102 Monster Bad Apple (16 oz can) 26 1.0
211 115 115 Monster Bad Apple (16 oz can) 26 1.0
221 122 122 Monster Bad Apple (16 oz can) 26 0.5
230 124 124 Monster Bad Apple (16 oz can) 26 0.5
319 169 169 Monster Bad Apple (16 oz can) 26 1.0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE meal_foods (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    meal_id INTEGER NOT NULL REFERENCES meals(id) ON DELETE CASCADE,
    food_id INTEGER NOT NULL REFERENCES foods(id),
    servings REAL NOT NULL DEFAULT 1.0
  );