meal_foods
4 rows where meal_id = 303
This data as json, CSV (advanced)
Suggested facets: servings
| id ▼ | meal_id | food_id | servings |
|---|---|---|---|
| 556 | 303 303 | Monster Bad Apple (16 oz can) 26 | 0.5 |
| 557 | 303 303 | Costa Vida Double Grilled Steak Taco with Pico, Cheese, and Black Beans (1 taco) 68 | 2.0 |
| 558 | 303 303 | Peanut Butter M&Ms (1 package) 43 | 0.5 |
| 559 | 303 303 | String Cheese (1 stick) 31 | 1.0 |
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
);