meal_foods

17 rows where food_id = 21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: servings

id ▼ meal_id food_id servings
11 9 9 Monster Pipeline Punch (16 oz can) 21 0.5
14 10 10 Monster Pipeline Punch (16 oz can) 21 0.5
23 16 16 Monster Pipeline Punch (16 oz can) 21 0.5
30 18 18 Monster Pipeline Punch (16 oz can) 21 0.5
93 51 51 Monster Pipeline Punch (16 oz can) 21 0.5
102 54 54 Monster Pipeline Punch (16 oz can) 21 1.0
107 57 57 Monster Pipeline Punch (16 oz can) 21 1.0
143 75 75 Monster Pipeline Punch (16 oz can) 21 1.0
153 81 81 Monster Pipeline Punch (16 oz can) 21 0.5
198 107 107 Monster Pipeline Punch (16 oz can) 21 1.0
240 128 128 Monster Pipeline Punch (16 oz can) 21 1.0
246 132 132 Monster Pipeline Punch (16 oz can) 21 1.0
258 139 139 Monster Pipeline Punch (16 oz can) 21 1.0
274 148 148 Monster Pipeline Punch (16 oz can) 21 0.5
290 155 155 Monster Pipeline Punch (16 oz can) 21 1.0
373 202 202 Monster Pipeline Punch (16 oz can) 21 1.0
385 209 209 Monster Pipeline Punch (16 oz can) 21 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
  );