meal_foods

19 rows where food_id = 49

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ meal_id food_id servings
125 64 64 Kirkland Protein Bar (1 bar) 49 1.0
130 67 67 Kirkland Protein Bar (1 bar) 49 1.0
142 75 75 Kirkland Protein Bar (1 bar) 49 1.0
212 116 116 Kirkland Protein Bar (1 bar) 49 1.0
225 123 123 Kirkland Protein Bar (1 bar) 49 1.0
260 140 140 Kirkland Protein Bar (1 bar) 49 1.0
278 149 149 Kirkland Protein Bar (1 bar) 49 1.0
285 153 153 Kirkland Protein Bar (1 bar) 49 1.0
310 164 164 Kirkland Protein Bar (1 bar) 49 1.0
323 171 171 Kirkland Protein Bar (1 bar) 49 1.0
332 175 175 Kirkland Protein Bar (1 bar) 49 1.0
344 183 183 Kirkland Protein Bar (1 bar) 49 1.0
353 189 189 Kirkland Protein Bar (1 bar) 49 1.0
357 192 192 Kirkland Protein Bar (1 bar) 49 1.0
362 196 196 Kirkland Protein Bar (1 bar) 49 1.0
377 205 205 Kirkland Protein Bar (1 bar) 49 1.0
381 208 208 Kirkland Protein Bar (1 bar) 49 1.0
390 211 211 Kirkland Protein Bar (1 bar) 49 1.0
402 215 215 Kirkland Protein Bar (1 bar) 49 1.0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
  );