home / nutrition

meal_foods

13 rows where food_id = 44

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: servings

id ▼ meal_id food_id servings
95 51 51 Fig Newtons (1 pack) 44 0.5
98 52 52 Fig Newtons (1 pack) 44 0.5
114 60 60 Fig Newtons (1 pack) 44 0.5
121 62 62 Fig Newtons (1 pack) 44 1.0
182 100 100 Fig Newtons (1 pack) 44 1.0
259 139 139 Fig Newtons (1 pack) 44 1.0
272 147 147 Fig Newtons (1 pack) 44 1.0
282 151 151 Fig Newtons (1 pack) 44 1.0
320 169 169 Fig Newtons (1 pack) 44 1.0
354 189 189 Fig Newtons (1 pack) 44 1.0
383 208 208 Fig Newtons (1 pack) 44 1.0
392 211 211 Fig Newtons (1 pack) 44 1.0
395 212 212 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.531ms