home / nutrition

meal_foods

18 rows where food_id = 31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: servings

id ▼ meal_id food_id servings
39 21 21 String Cheese (1 stick) 31 1.0
47 25 25 String Cheese (1 stick) 31 1.0
59 29 29 String Cheese (1 stick) 31 1.0
119 61 61 String Cheese (1 stick) 31 1.0
126 64 64 String Cheese (1 stick) 31 1.0
185 102 102 String Cheese (1 stick) 31 1.0
277 149 149 String Cheese (1 stick) 31 1.0
436 235 235 String Cheese (1 stick) 31 1.0
482 258 258 String Cheese (1 stick) 31 2.0
510 276 276 String Cheese (1 stick) 31 1.0
520 283 283 String Cheese (1 stick) 31 1.0
530 287 287 String Cheese (1 stick) 31 1.0
535 289 289 String Cheese (1 stick) 31 1.0
545 295 295 String Cheese (1 stick) 31 1.0
559 303 303 String Cheese (1 stick) 31 1.0
577 312 312 String Cheese (1 stick) 31 1.0
585 315 315 String Cheese (1 stick) 31 1.0
600 324 324 String Cheese (1 stick) 31 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.735ms