meal_foods
4 rows where food_id = 70
This data as json, CSV (advanced)
Suggested facets: servings
| id ▼ | meal_id | food_id | servings |
|---|---|---|---|
| 345 | 184 184 | Large Pepperoni Pizza Slice (1 slice) 70 | 1.0 |
| 439 | 237 237 | Large Pepperoni Pizza Slice (1 slice) 70 | 1.0 |
| 450 | 242 242 | Large Pepperoni Pizza Slice (1 slice) 70 | 1.0 |
| 500 | 270 270 | Large Pepperoni Pizza Slice (1 slice) 70 | 2.6315789473684212 |
Advanced export
JSON shape: default, array, newline-delimited, object
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
);