meal_foods
17 rows where food_id = 43
This data as json, CSV (advanced)
Suggested facets: servings
| id ▼ | meal_id | food_id | servings |
|---|---|---|---|
| 79 | 42 42 | Peanut Butter M&Ms (1 package) 43 | 1.0 |
| 188 | 104 104 | Peanut Butter M&Ms (1 package) 43 | 1.0 |
| 227 | 123 123 | Peanut Butter M&Ms (1 package) 43 | 1.0 |
| 279 | 149 149 | Peanut Butter M&Ms (1 package) 43 | 1.0 |
| 417 | 223 223 | Peanut Butter M&Ms (1 package) 43 | 1.0 |
| 437 | 236 236 | Peanut Butter M&Ms (1 package) 43 | 0.5 |
| 446 | 240 240 | Peanut Butter M&Ms (1 package) 43 | 0.5 |
| 504 | 273 273 | Peanut Butter M&Ms (1 package) 43 | 0.5 |
| 507 | 275 275 | Peanut Butter M&Ms (1 package) 43 | 1.0 |
| 518 | 281 281 | Peanut Butter M&Ms (1 package) 43 | 0.5 |
| 521 | 283 283 | Peanut Butter M&Ms (1 package) 43 | 0.5 |
| 531 | 287 287 | Peanut Butter M&Ms (1 package) 43 | 0.5 |
| 544 | 295 295 | Peanut Butter M&Ms (1 package) 43 | 1.0 |
| 558 | 303 303 | Peanut Butter M&Ms (1 package) 43 | 0.5 |
| 566 | 308 308 | Peanut Butter M&Ms (1 package) 43 | 1.0 |
| 586 | 316 316 | Peanut Butter M&Ms (1 package) 43 | 1.0 |
| 603 | 325 325 | 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
);