meal_foods
7 rows where food_id = 4
This data as json, CSV (advanced)
| id ▼ | meal_id | food_id | servings |
|---|---|---|---|
| 66 | 34 34 | JJ Slim #4 Double Turkey Double Cheese 4 | 1.0 |
| 181 | 99 99 | JJ Slim #4 Double Turkey Double Cheese 4 | 1.0 |
| 210 | 115 115 | JJ Slim #4 Double Turkey Double Cheese 4 | 1.0 |
| 283 | 152 152 | JJ Slim #4 Double Turkey Double Cheese 4 | 1.0 |
| 307 | 162 162 | JJ Slim #4 Double Turkey Double Cheese 4 | 1.0 |
| 346 | 184 184 | JJ Slim #4 Double Turkey Double Cheese 4 | 1.0 |
| 355 | 190 190 | JJ Slim #4 Double Turkey Double Cheese 4 | 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
);