meal_foods
3 rows where meal_id = 287
This data as json, CSV (advanced)
| id ▼ | meal_id | food_id | servings |
|---|---|---|---|
| 529 | 287 287 | Monster Pipeline Punch (16 oz can) 21 | 0.3 |
| 530 | 287 287 | String Cheese (1 stick) 31 | 1.0 |
| 531 | 287 287 | Peanut Butter M&Ms (1 package) 43 | 0.5 |
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
);