meal_foods
3 rows where meal_id = 322
This data as json, CSV (advanced)
Suggested facets: servings
| id ▼ | meal_id | food_id | servings |
|---|---|---|---|
| 594 | 322 322 | Little Caesars Crazy Bread (1 breadstick) 89 | 2.0 |
| 595 | 322 322 | Little Caesars Stuffed Crust Pepperoni Pizza (1 slice, 1/8 pizza) 90 | 1.0 |
| 596 | 322 322 | Chobani Yogurt (1 container) 11 | 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
);