meal_foods
9 rows where food_id = 33
This data as json, CSV (advanced)
Suggested facets: servings
| id ▼ | meal_id | food_id | servings |
|---|---|---|---|
| 41 | 23 23 | McDonald's Sausage Biscuit with Egg (1 sandwich) 33 | 2.0 |
| 61 | 31 31 | McDonald's Sausage Biscuit with Egg (1 sandwich) 33 | 1.0 |
| 245 | 132 132 | McDonald's Sausage Biscuit with Egg (1 sandwich) 33 | 1.0 |
| 421 | 226 226 | McDonald's Sausage Biscuit with Egg (1 sandwich) 33 | 1.0 |
| 454 | 244 244 | McDonald's Sausage Biscuit with Egg (1 sandwich) 33 | 1.0 |
| 515 | 279 279 | McDonald's Sausage Biscuit with Egg (1 sandwich) 33 | 1.0 |
| 567 | 309 309 | McDonald's Sausage Biscuit with Egg (1 sandwich) 33 | 1.0 |
| 578 | 313 313 | McDonald's Sausage Biscuit with Egg (1 sandwich) 33 | 1.0 |
| 590 | 319 319 | McDonald's Sausage Biscuit with Egg (1 sandwich) 33 | 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
);