meal_foods
18 rows where food_id = 31
This data as json, CSV (advanced)
Suggested facets: servings
| id ▼ | meal_id | food_id | servings |
|---|---|---|---|
| 39 | 21 21 | String Cheese (1 stick) 31 | 1.0 |
| 47 | 25 25 | String Cheese (1 stick) 31 | 1.0 |
| 59 | 29 29 | String Cheese (1 stick) 31 | 1.0 |
| 119 | 61 61 | String Cheese (1 stick) 31 | 1.0 |
| 126 | 64 64 | String Cheese (1 stick) 31 | 1.0 |
| 185 | 102 102 | String Cheese (1 stick) 31 | 1.0 |
| 277 | 149 149 | String Cheese (1 stick) 31 | 1.0 |
| 436 | 235 235 | String Cheese (1 stick) 31 | 1.0 |
| 482 | 258 258 | String Cheese (1 stick) 31 | 2.0 |
| 510 | 276 276 | String Cheese (1 stick) 31 | 1.0 |
| 520 | 283 283 | String Cheese (1 stick) 31 | 1.0 |
| 530 | 287 287 | String Cheese (1 stick) 31 | 1.0 |
| 535 | 289 289 | String Cheese (1 stick) 31 | 1.0 |
| 545 | 295 295 | String Cheese (1 stick) 31 | 1.0 |
| 559 | 303 303 | String Cheese (1 stick) 31 | 1.0 |
| 577 | 312 312 | String Cheese (1 stick) 31 | 1.0 |
| 585 | 315 315 | String Cheese (1 stick) 31 | 1.0 |
| 600 | 324 324 | String Cheese (1 stick) 31 | 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
);