meal_foods

28 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: meal_id, food_id, servings

id ▼ meal_id food_id servings
10 9 9 McDonald's Sausage Biscuit with Egg 20 1.0
11 9 9 Monster Pipeline Punch (16 oz can) 21 0.5
12 10 10 Harmons Chicken Tenders (1 lb) 5 0.7
13 10 10 Glazed Donut (1 donut) 18 0.5
14 10 10 Monster Pipeline Punch (16 oz can) 21 0.5
15 11 11 Glazed Donut (1 donut) 18 0.5
16 11 11 Protein Drink (milk, whey, AG1, creatine, fiber) 6 1.0
17 11 11 Chobani Yogurt (1 container) 11 1.0
19 13 13 Five Guys Cheeseburger (ketchup only) 22 1.0
20 14 14 Chocolate Croissant (1 croissant) 23 1.0
21 15 15 Fig Newtons snack pack (57g) 24 1.0
22 16 16 Protein Drink (milk, whey, AG1, creatine, fiber) 6 1.0
23 16 16 Monster Pipeline Punch (16 oz can) 21 0.5
24 16 16 Fig Newtons snack pack (57g) 24 0.5
27 18 18 Harmons Chicken Tenders (1 lb) 5 0.65
28 18 18 Chobani Yogurt (1 container) 11 1.0
29 18 18 Chocolate Donut (1 donut) 25 1.0
30 18 18 Monster Pipeline Punch (16 oz can) 21 0.5
31 19 19 Protein Drink (milk, whey, AG1, creatine, fiber) 6 1.0
32 19 19 Monster Bad Apple (16 oz can) 26 0.5
33 20 20 Monster Bad Apple (16 oz can) 26 0.5
34 20 20 Jimmy Dean Croissant Sausage & Cheese Sandwich 27 1.0
35 20 20 Strawberry Yoggis (1 serving) 28 1.0
36 21 21 Core Power Fairlife 42g Protein Shake (1 bottle) 29 1.0
37 21 21 Chocolate Donut (1 donut) 25 1.0
38 21 21 Fig Newtons snack pack (57g) 24 1.0
39 21 21 String Cheese (1 stick) 31 1.0
40 22 22 Peanut M&M's fun size (1 pack) 32 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
  );