-- User Table CREATE TABLE User ( user_id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, password VARCHAR(100) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );

-- Meal Table CREATE TABLE Meal ( meal_id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, meal_name VARCHAR(50) NOT NULL, meal_date DATE NOT NULL, FOREIGN KEY (user_id) REFERENCES User(user_id) ON DELETE CASCADE );

-- FoodItem Table CREATE TABLE FoodItem ( food_item_id INT AUTO_INCREMENT PRIMARY KEY, food_name VARCHAR(50) NOT NULL, calories_per_100g DECIMAL(5,2), protein_per_100g DECIMAL(5,2), carbs_per_100g DECIMAL(5,2), fats_per_100g DECIMAL(5,2) );

-- Nutrient Table (stores details of food items in each meal) CREATE TABLE Nutrient ( nutrient_id INT AUTO_INCREMENT PRIMARY KEY, meal_id INT, food_item_id INT, quantity_in_grams DECIMAL(5,2) NOT NULL, -- quantity of food item in the meal FOREIGN KEY (meal_id) REFERENCES Meal(meal_id) ON DELETE CASCADE, FOREIGN KEY (food_item_id) REFERENCES FoodItem(food_item_id) ON DELETE CASCADE );