meal_foods
4 rows where meal_id = 212
This data as json, CSV (advanced)
| id ▼ | meal_id | food_id | servings |
|---|---|---|---|
| 393 | 212 212 | Protein Drink (high protein milk, whey, AG1, creatine, fiber) 40 | 1.0 |
| 394 | 212 212 | Monster Bad Apple Energy Drink (1 can) 75 | 1.0 |
| 395 | 212 212 | Fig Newtons (1 pack) 44 | 1.0 |
| 396 | 212 212 | That's It Bar (1 bar) 52 | 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
);