# 26.03.03 — Add Nutrition Data to Ingredients Table

## Status Quo

Food is recorded via name or photo in add-log.

→ Ingredients are detected.

**BAD:** Gemini detects nutrition info of the food directly.

## Target State

Food is recorded via name or photo in add-log.

→ Ingredients are detected.

**TARGET:** For each ingredient, look up the `ingredients` table to retrieve nutrition info.

Sum the nutrition of all ingredients.

If an ingredient is not in the `ingredients` table, create a new record.

## Prefill: Ingredients from Food History

Prefill the `ingredients` table with all ingredients present in the history below.

---

**26.03.03**
- Avocado, Olive Oil
- TJ Hearty Mushroom Soup: tomato, onion, carrot, kidney beans, cannellini beans

**26.03.02**
- Bread, Milk, Beef, Iceberg Lettuce

**26.03.01**
- Avocado, Rice, Beef Radish Soup
- Bread, Milk, Beef, Iceberg Lettuce

**26.02.28**
- Mixed Rice, Beef Radish Soup
- Curry Ramen, Potato Fries, Vanilla Milk Shake

**26.02.27**
- Mixed Rice, Salmon, Red Thai Curry
- Nuts, Rice, Salted Duck Egg, Beef

**26.02.26**
- Banana, Avocado, Coffee
- 호빵, Broccoli, Beef Ham, Cheese

**26.02.25**
- Banana, Beef, Seaweed, Rice

**26.02.24**
- Shrimp Tempura, Ho Bbang, Doenjang-Jjigae, Seasoned Rice
- Broccoli, Croissant, Ham, Cheese, Eggs

**26.02.23**
- Rice, Butter, Spam Meat, Yellow Onion, Garlic, Doen Jang, Lettuce, Tofu, Pyogo Mushroom, Radish

**26.02.22**
- Beef Kebab, Yellow Onions, Cilantro, Rice
- Seaweed Soup, Chicken Breast, Rice

**26.02.21**
- Morning Glory Jeon, Doenjang Jjigae with Tofu

**26.02.20**
- Morning Glory Jeon, Flounder Fish Seaweed Soup

**26.02.19**
- In N Out Burger
- Sushi

**26.02.18**
- Seaweed Soup with Flounder Fish
- Lamb Hot Pot, Lettuce, Fish Ball with Roe

**26.02.17**
- Pepperoni Pizza, Rotisserie Chicken

**26.02.16**
- Seaweed Soup
- Branzino, Lobster Roll
- Nuts
- Gotts Roadside Burgers: Californian Burger, Avocado Burger

**26.02.15**
- Jeyook Pork, Rice

**26.02.14**
- Roy's: Venison, Volcanic Sushi
- Samgyeopsal, Lettuce

**26.02.13**
- Subway Club: all vegetables

**26.02.12**
- Tofu, Mixed Rice, Bell Pepper, Blackberries, Orange, Pineapple, Cashew Nuts, Cranberry, Macadamia Nuts

**26.02.11**
- Oil Pasta with Olive Oil, Beef Kebab, Banana
- Tofu
- Instant Ramen

**26.02.10**
- Banana, Coffee
- Shrimp, Pasta, Cilantro, Lettuce, Tomato Basil Sauce

**26.02.09**
- Instant Ramen, Sardine
- Muffins with Raspberry
- Whole Milk
- Kebab, Rice, Kimchi
- Salmon, Blackberries

**26.02.08**
- TJ Mushroom Soup
- Duck Egg, Rice
- Chicken Breast, Lentil
- Sardine, Pasta

**26.02.07**
- TJ Mushroom Soup
- Chicken Breast, Lentil

**26.02.06**
- TJ Hearty Mushroom Soup, Lentils, Chicken Breast, Blackberries, Orange

**26.02.05**
- Mixed Rice, Beef, Tomato Soup with Mushroom, Bell Pepper, Orange

**26.02.04**
- Bell Pepper, Blackberries, Fried Eggs, Beef, Red Thai Curry

**26.02.03**
- Tomato Sauce Pasta, Beef, TJ Harvest Chili Soup

**26.02.01**
- Hakata Tonkotsu Ramen (pork, wood ear mushroom, ginger, seaweed, green onion, egg)

**26.01.31**
- Salmon, Lettuce, Rice

**26.01.30**
- Banana, Milk
- Spinach, Potato Chips, Lettuce, Chicken Breast

**26.01.29**
- Mixed Rice, Yellow Onion, Duck Egg, Cilantro
- Red Thai Curry (Chicken, Pumpkin, Onion, Tomato, Mushroom, Green Beans, Coconut Milk, Red Curry Paste, Lemongrass, Ginger)

**26.01.28**
- Beef Pho
- Red Thai Curry (Chicken, Pumpkin, Onion, Tomato, Mushroom, Green Beans, Coconut Milk, Red Curry Paste, Lemongrass, Ginger), Salmon, Pistachio, Banana

**26.01.27**
- Harvest Chili (Trader Joe's): Black Beans, Onion, Butternut Squash, Tomato, Cauliflower, Pumpkin, Sweet Potato, French Green Lentils, Red Quinoa, Guajillo Pepper, Garlic, Cilantro, Lime, Cumin, Coriander, Oregano, Turmeric, Cayenne Pepper, Smoked Paprika

**26.01.26**
- Calamari, Mussels, Oyster, Spinach, Pasta

**26.01.25**
- Salmon, Rice, Spinach, Blueberries, Red Wine
- Hearty Mushroom Soup (Trader Joe's): Mushroom, Coconut Milk, Carrot, Kale, Onion, Celery, Tomato, Garlic
- Almonds, Cashews

**26.01.24**
- Spaghetti, Scallion, Garlic, Salted Shrimp
- Bell Pepper
- Tofu, Lettuce

**26.01.23**
- Banana
- Beef Sirloin, Radish, Pyogo Mushroom
- Mapo Tofu, Lettuce, Rice, Cilantro
- Red Wine
- Mixed Rice, Instant Ramen

**26.01.22**
- Beef Sirloin, Radish, Pyogo Mushroom
- Mapo Tofu, Lettuce, Rice, Cilantro
- Red Wine, Cheese

**26.01.21**
- Beef Sirloin, Radish, Pyogo Mushroom
- Mapo Tofu, Lettuce, Rice, Cilantro
- Red Wine, Cheese

**26.01.20**
- Bo Kho Noodle Soup, Sugar Cane Juice

**26.01.19**
- Sandwich: Bread, Beef Steak, Lettuce, Tomato, Cucumber, Green Bell Pepper, Red Onion, Spinach, Avocado, Black Olives

**26.01.18**
- Salmon Fillet, Brown Rice, Iceberg Lettuce, Banana

**26.01.17**
- Iceberg Lettuce, Mixed Rice, Salmon, Tangerine

**26.01.16**
- Supplements: Vit C, Vit D, Fish Oil, Lutein and Zeaxanthin, Quercetin and Bromelain, Homocysteine Nutrients, Vit B12
- Coffee
- Cherry Tomatoes, Banana, Mixed Rice
- Beef Sirloin, Radish, Onion

**26.01.15**
- Salted Duck Egg, Kimchi, Mixed Rice, Beef Sirloin, Radish, Onion

**26.01.14**
- Beef Sirloin, Preserved Duck Egg, Onion, Radish, Rice, Figs

**26.01.13**
- Mala Hua Jiao You, Lettuce, Kale, Silken Tofu, Ground Beef
- Banana, Canned Anchovies, Instant Ramen, Coffee

**26.01.12**
- Mala Hua Jiao You, Lettuce, Kale, Silken Tofu, Ground Beef

**26.01.11**
- Beef, Onion, Garlic, Cilantro, Parsley, Dill, Coriander, Black Pepper, Salt, Cumin, Barberry, Lavash, Tomato, Potatoes, Pomegranate Seeds

**26.01.10**
- Roasted Duck, Chicken, Ginseng

**26.01.09**
- Chicken Breast, Pine Nut, Pear, Rice, Sesame Oil, Egg Yolk
- Tomato, Bean, Carrot, Celery

**26.01.08**
- Lentil, Celery, Carrot, Rice, Seaweed, Egg Yolk

**26.01.07**
- Orange Bell Pepper
- White Rice
- Egg, Tomato
- Mackerel, Radish, Ginger, Garlic, Green Onion, Yellow Onion

**26.01.06**
- Orange Bell Pepper
- White Rice
- Egg, Tomato
- Mackerel, Radish, Ginger, Garlic, Green Onion, Yellow Onion

**26.01.05**
- Galbi Jjim: Beef Short Ribs, Radish, Pyogo Mushrooms, Yellow Onion, Pine Nuts
- Sweet Potatoes (white), Milk

**26.01.04**
- Tandoori Chicken Pizza: Red Onion, Garlic, Cheese, Bread
- Galbi Jjim: Beef Short Ribs, Radish, Pyogo Mushrooms, Yellow Onion, Pine Nuts

**26.01.03**
- Tandoori Chicken Pizza: Red Onion, Garlic, Cheese, Bread

**26.01.02**
- Banana, Century Egg, Beef, Curry, Chicken Breast, Frozen Strawberries

**26.01.01**
- Banana, Curry, Beef, Chicken Breast, Rice, Hakata Tonkotsu Ramen (wood ear mushroom, corn, pork bone broth, wheat noodles)

**25.12.31**
- Banana, Curry, Beef, Chicken Breast, Rice, Tangerines

**25.12.30**
- Banana, Curry, Beef, Rice, Kimchi, Tangerines, Wine, Cheese

**25.12.29**
- Garlic, Olive Oil, Pasta, Tofu, Green Onion, Egg, Avocado, Soy Sauce, Kimchi, Bell Pepper, Broccoli, Beef Ribeye, Cheese, Wine, Eggplant, Shishito Pepper

**25.12.28**
- Broccoli, Olive Oil Garlic Pasta, Cheese, Egg, Tofu, Soy Sauce, Banana, Avocado, Bell Pepper

**25.12.27**
- Mushroom Crimini, Tomato, Celery, Shishito Pepper

**25.12.26**
- Almond, Chili, Lime, Cod, Rice, Avocado, Banana

**25.12.25**
- Pesto Pasta, Beef, Mushroom, Salmon, Avocado, Banana

**25.12.24**
- Banana, Almond, Thyme, Chili, Green Peas, Mushroom Crimini, Carrots, White Beans, Red/Purple Onion, Tomato, Celery, Leafy Greens, Broth

**25.12.23**
- Lettuce, Salted Shrimp, Chicken Breast (garlic, green onion, mapo tofu sauce), Pine Nuts, Green Peas, Anchovies

**25.12.22**
- Lettuce, Tofu, Rice, Salted Shrimp, Anchovies, Chicken Breast, Green Onion, Garlic, Mapo Tofu Sauce

**25.12.21**
- Salmon, Lettuce, Carrot

**25.12.20**
- Fried Chicken, Radish

**25.12.19**
- Shrimp Hargow, Tomato, Egg, White Rice, Green Onion, Garlic, Greek Yogurt, Strawberry Jam

**25.12.18**
- White Rice, Anchovy, Kimchi, Tofu, Tomato, Green Onion, Garlic, Olive Oil, Pistachio

**25.12.17**
- Banana

**25.12.16**
- Kimchi, Rice, Beef, Chicken Breast, Mushroom Soup
- Bread, Apricot Jam, Coffee
- Tomato, Eggs, Cup Ramyeon

**25.12.15**
- Kimchi, White Rice
- Beef Ribeye, Mushrooms

**25.12.14**
- Brown Beech Mushroom, White Beech Mushroom, Oyster Mushroom, King Oyster Mushroom, Pyogo Mushroom, Enoki Mushroom
- Beef Ribeye
- Blueberries, Mandarin

**25.12.13**
- Coffee, Hargow (Shrimp Dimsum), Seogi Mushroom (Iwatake), Lentil

**25.12.12**
- Coffee, Coca-Cola, Milk Bread, Lettuce, Ground Beef (15% fat), Pork Sausage
- Indian Curry (Tikka Masala)

**25.12.11**
- Seaweed, Sausage, Noodle, Pistachio, Coffee
- Milk Bread, Lettuce, Ground Beef (15% fat)

**25.12.10**
- Carrots, Eggplant, Pork Sausage, Salmon, Honey Mustard, Pistachio

**25.12.09**
- Quinoa, Lettuce, Chicken Tikka Masala, Milk, Coffee
- Century Egg, Tofu, Egg Sauce, Taiwanese Beef Noodle
- Pork Sausage, Grilled Salmon, Eggplant, Pistachio

**25.12.08**
- Chicken Tikka Masala Curry, Quinoa, Lettuce, Coffee with Ginseng Extract

**25.12.07**
- Coffee with Saffron
- Salmon Sandwich, Egg Lettuce Sandwich, Candied Fruits

**25.12.06**
- Coffee, Sardine, Olive Oil, Ramen, Lettuce, Quinoa, Chicken Breast

**25.12.05**
- Corn (Butter, Old Bay)
- Ramen, Carrot, Eggs
- Supplements: Vitamin D, Lutein and Zeaxanthin, NAC, Omega 3 and Astaxanthin, Homocysteine Nutrients (Riboflavin, Vitamin B6, Folate, Vitamin B12, TMG)

**25.12.04**
- Quinoa, Anchovy, Banana, Bean Sprouts, Coffee, Chicken Breast

**25.12.03**
- Eggs, Coffee, Greek Yogurt, Manuka Honey, Quinoa, Carrots, Potato Chips

**25.12.02**
- Lettuce, Chicken Breast, Quinoa
- Anchovy, Bean Sprouts, Tangerine, Coffee, Potato Chips

**25.12.01**
- Coffee
- Lettuce, Chicken Breast, Quinoa
- Banana, Anchovy

**25.11.30**
- Beef Radish Soup
- Rice, Sesame Oil, Salt
- Coffee, Banana

**25.11.29**
- Coffee with Creamer and Milk
- Banana
- Beef Ribeye, Sesame Oil, Salt
- Spinach, Anchovy, Natto, Rice
- Beef Radish Soup

**25.11.28**
- Banana
- Beef Sirloin Steak
- Salad: Carrot, Lettuce, Red Cabbage, Walnut