home / nutrition

meal_foods

16 rows where food_id = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: servings

id ▼ meal_id food_id servings
81 44 44 Beef & Cheese Taco (flour tortilla, 1 taco) 7 2.0
90 49 49 Beef & Cheese Taco (flour tortilla, 1 taco) 7 2.0
103 54 54 Beef & Cheese Taco (flour tortilla, 1 taco) 7 2.0
110 58 58 Beef & Cheese Taco (flour tortilla, 1 taco) 7 2.0
138 72 72 Beef & Cheese Taco (flour tortilla, 1 taco) 7 1.0
139 73 73 Beef & Cheese Taco (flour tortilla, 1 taco) 7 1.0
146 77 77 Beef & Cheese Taco (flour tortilla, 1 taco) 7 1.0
187 103 103 Beef & Cheese Taco (flour tortilla, 1 taco) 7 2.0
201 109 109 Beef & Cheese Taco (flour tortilla, 1 taco) 7 2.0
217 119 119 Beef & Cheese Taco (flour tortilla, 1 taco) 7 1.0
232 124 124 Beef & Cheese Taco (flour tortilla, 1 taco) 7 1.0
252 136 136 Beef & Cheese Taco (flour tortilla, 1 taco) 7 1.0
268 145 145 Beef & Cheese Taco (flour tortilla, 1 taco) 7 1.0
280 150 150 Beef & Cheese Taco (flour tortilla, 1 taco) 7 3.0
298 157 157 Beef & Cheese Taco (flour tortilla, 1 taco) 7 2.0
338 180 180 Beef & Cheese Taco (flour tortilla, 1 taco) 7 2.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
  );
Powered by Datasette · Queries took 3.549ms