home / nutrition

meal_foods

17 rows where food_id = 43

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: servings

id ▼ meal_id food_id servings
79 42 42 Peanut Butter M&Ms (1 package) 43 1.0
188 104 104 Peanut Butter M&Ms (1 package) 43 1.0
227 123 123 Peanut Butter M&Ms (1 package) 43 1.0
279 149 149 Peanut Butter M&Ms (1 package) 43 1.0
417 223 223 Peanut Butter M&Ms (1 package) 43 1.0
437 236 236 Peanut Butter M&Ms (1 package) 43 0.5
446 240 240 Peanut Butter M&Ms (1 package) 43 0.5
504 273 273 Peanut Butter M&Ms (1 package) 43 0.5
507 275 275 Peanut Butter M&Ms (1 package) 43 1.0
518 281 281 Peanut Butter M&Ms (1 package) 43 0.5
521 283 283 Peanut Butter M&Ms (1 package) 43 0.5
531 287 287 Peanut Butter M&Ms (1 package) 43 0.5
544 295 295 Peanut Butter M&Ms (1 package) 43 1.0
558 303 303 Peanut Butter M&Ms (1 package) 43 0.5
566 308 308 Peanut Butter M&Ms (1 package) 43 1.0
586 316 316 Peanut Butter M&Ms (1 package) 43 1.0
603 325 325 Peanut Butter M&Ms (1 package) 43 0.5

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.722ms