Food Data Inspection

Searching for: Burger Chicken

Name: Burger Chicken (1)
Category: non-veg
Calories: 450
Carbs: 40g
Fat: 20g
Protein: 22g

Searching for: Chole Bhature

Name: Chole Bhature (1 plate)
Category: veg
Calories: 450
Carbs: 60g
Fat: 18g
Protein: 14g

Searching for: Idli

Name: Idli (1 piece)
Category: veg
Calories: 60
Carbs: 8g
Fat: 0.5g
Protein: 2g

Table Structure (Foods)

id (int)
food_name (varchar(255))
category (varchar(100))
calories (int)
protein (float)
iron (float)
calcium (float)
carbs (double)
fat (double)
fiber (double)
sodium (double)
vitamin_d (double)

Table Structure (Meals)

id (int)
user_id (int)
meal_type (varchar(50))
food_name (varchar(150))
calories (float)
protein (float)
iron (float)
calcium (float)
date (date)
carbs (double)
fat (double)
fiber (double)
sodium (double)
is_eaten (tinyint(1))
vitamin_d (double)