home / nutrition

meal_foods

13 rows where food_id = 52

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: servings

id ▼ meal_id food_id servings
141 75 75 That's It Bar (1 bar) 52 2.0
178 97 97 That's It Bar (1 bar) 52 1.0
203 110 110 That's It Bar (1 bar) 52 1.0
218 120 120 That's It Bar (1 bar) 52 1.0
292 155 155 That's It Bar (1 bar) 52 1.0
300 158 158 That's It Bar (1 bar) 52 1.0
304 160 160 That's It Bar (1 bar) 52 1.0
328 173 173 That's It Bar (1 bar) 52 1.0
331 174 174 That's It Bar (1 bar) 52 1.0
339 181 181 That's It Bar (1 bar) 52 1.0
361 195 195 That's It Bar (1 bar) 52 1.0
384 208 208 That's It Bar (1 bar) 52 1.0
396 212 212 That's It Bar (1 bar) 52 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.47ms