home / nutrition

meal_foods

4 rows where meal_id = 211

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ meal_id food_id servings
389 211 211 Fairlife Protein Shake (30g protein, 1 bottle) 67 1.0
390 211 211 Kirkland Protein Bar (1 bar) 49 1.0
391 211 211 Chocolate Donut (1 donut) 25 1.0
392 211 211 Fig Newtons (1 pack) 44 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
  );
Powered by Datasette · Queries took 3.265ms