meal_foods

6 rows where food_id = 41

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ meal_id food_id servings
60 30 30 Kirkland Protein Bar (21g protein, 60g bar) 41 1.0
435 234 234 Kirkland Protein Bar (21g protein, 60g bar) 41 1.0
448 241 241 Kirkland Protein Bar (21g protein, 60g bar) 41 1.0
461 247 247 Kirkland Protein Bar (21g protein, 60g bar) 41 1.0
480 258 258 Kirkland Protein Bar (21g protein, 60g bar) 41 1.0
490 263 263 Kirkland Protein Bar (21g protein, 60g bar) 41 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
  );