meal_foods
13 rows where food_id = 44
This data as json, CSV (advanced)
Suggested facets: servings
| id ▼ | meal_id | food_id | servings |
|---|---|---|---|
| 95 | 51 51 | Fig Newtons (1 pack) 44 | 0.5 |
| 98 | 52 52 | Fig Newtons (1 pack) 44 | 0.5 |
| 114 | 60 60 | Fig Newtons (1 pack) 44 | 0.5 |
| 121 | 62 62 | Fig Newtons (1 pack) 44 | 1.0 |
| 182 | 100 100 | Fig Newtons (1 pack) 44 | 1.0 |
| 259 | 139 139 | Fig Newtons (1 pack) 44 | 1.0 |
| 272 | 147 147 | Fig Newtons (1 pack) 44 | 1.0 |
| 282 | 151 151 | Fig Newtons (1 pack) 44 | 1.0 |
| 320 | 169 169 | Fig Newtons (1 pack) 44 | 1.0 |
| 354 | 189 189 | Fig Newtons (1 pack) 44 | 1.0 |
| 383 | 208 208 | Fig Newtons (1 pack) 44 | 1.0 |
| 392 | 211 211 | Fig Newtons (1 pack) 44 | 1.0 |
| 395 | 212 212 | Fig Newtons (1 pack) 44 | 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
);