-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 18, 2024 at 04:38 PM
-- Server version: 5.7.44
-- PHP Version: 8.1.27

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `jlee5092_idsn599`
--

-- --------------------------------------------------------

--
-- Table structure for table `food_1`
--

CREATE TABLE `food_1` (
  `Date` varchar(7) DEFAULT NULL,
  `Food` varchar(45) DEFAULT NULL,
  `Before` decimal(3,1) DEFAULT NULL,
  `After` decimal(3,1) DEFAULT NULL,
  `Difference` decimal(3,1) DEFAULT NULL,
  `Meal` varchar(9) DEFAULT NULL,
  `Size` varchar(6) DEFAULT NULL,
  `Cuisine` varchar(13) DEFAULT NULL,
  `Where` varchar(11) DEFAULT NULL,
  `Company` varchar(14) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `food_1`
--

INSERT INTO `food_1` (`Date`, `Food`, `Before`, `After`, `Difference`, `Meal`, `Size`, `Cuisine`, `Where`, `Company`) VALUES
('1/21/24', 'Chapresso Iron Goddess Drink w/ Boba', 9.0, 9.5, 0.5, 'Snack', 'Small', 'Taiwanese', 'Restaurant', 'With Friends'),
('1/21/24', 'Crab House Raw Marinated Crab + Banchan', 9.0, 8.0, -1.0, 'Dinner', 'Large', 'Korean', 'Take Out', 'With Boyfriend'),
('1/22/24', 'McDonald Deluxe Plate', 9.0, 9.0, 0.0, 'Breakfast', 'Medium', 'American', 'Take Out', 'With Boyfriend'),
('1/22/24', 'Daikokuya Tonkatsu Ramen', 8.0, 9.0, 1.0, 'Dinner', 'Small', 'Japanese', 'Restaurant', 'With Friends'),
('1/23/24', 'Caesar Wrap + Chips', 4.5, 4.3, -0.2, 'Lunch', 'Medium', 'American', 'Take Out', 'Alone'),
('1/23/24', 'French Shallot Soup + Arugula Salad', 8.0, 10.0, 2.0, 'Dinner', 'Medium', 'French', 'Restaurant', 'With Work'),
('1/23/24', 'Gulf Fish Amandine', 10.0, 7.0, -3.0, 'Dinner', 'Large', 'French', 'Restaurant', 'With Work'),
('1/24/24', 'Avocado Toast, Greek Yogurt, Smoked Salmon', 9.0, 10.0, 1.0, 'Breakfast', 'Medium', 'American', 'Restaurant', 'With Work'),
('1/24/24', 'Gumbo, Salad, Pork Loin', 10.0, 11.0, 1.0, 'Lunch', 'Medium', 'American', 'Restaurant', 'With Work'),
('1/24/24', 'Gumbo & Caesar Salad', 9.0, 13.0, 4.0, 'Dinner', 'Medium', 'American', 'Restaurant', 'With Work'),
('1/24/24', 'Black Angus Beef Steak', 8.0, 7.5, -0.5, 'Dinner', 'Large', 'American', 'Restaurant', 'With Work'),
('1/25/24', 'Bacon & Eggs', 9.0, 10.0, 1.0, 'Breakfast', 'Medium', 'American', 'Restaurant', 'With Work'),
('1/25/24', 'Steak and Salad with Cookie', 7.5, 10.0, 2.5, 'Lunch', 'Medium', 'American', 'Restaurant', 'With Work'),
('1/25/24', 'Crawfish', 8.0, 8.0, 0.0, 'Snack', 'Medium', 'American', 'Restaurant', 'With Friends'),
('1/25/24', 'Carbonara and Steak', 4.0, 5.0, 1.0, 'Dinner', 'Medium', 'American', 'Restaurant', 'With Work'),
('1/26/24', 'Beignets', 8.0, 9.0, 1.0, 'Breakfast', 'Small', 'American', 'Restaurant', 'With Friends'),
('1/26/24', 'Hot Dog & Chips', 8.0, 7.0, -1.0, 'Lunch', 'Small', 'American', 'Take Out', 'Alone'),
('1/26/24', 'Hot Pot Lamb + Veggies', 8.0, 10.0, 2.0, 'Dinner', 'Medium', 'Japanese', 'Restaurant', 'With Boyfriend'),
('1/27/24', 'Orobae Metal Buddha Boba', 7.0, 9.0, 2.0, 'Snack', 'Small', 'Taiwanese', 'Restaurant', 'With Friends'),
('1/27/24', 'Sup Noodle Bar Pho', 9.0, 11.0, 2.0, 'Dinner', 'Medium', 'Vietnamese', 'Restaurant', 'With Friends'),
('1/28/24', 'Donuts', 7.0, 7.3, 0.3, 'Breakfast', 'Small', 'American', 'Take Out', 'With Family'),
('1/28/24', 'TAPEX Fishcake', 6.0, 8.0, 2.0, 'Lunch', 'Small', 'Taiwanese', 'Take Out', 'Alone'),
('1/28/24', 'All that Shabu Hot Pot', 8.0, 9.0, 1.0, 'Dinner', 'Large', 'Japanese', 'Restaurant', 'With Family'),
('1/29/24', 'Fried Rice & Fried Noodle', 7.0, 7.0, 0.0, 'Lunch', 'Medium', 'Chinese', 'Take Out', 'With Boyfriend'),
('1/29/24', 'Naengmyeon', 9.0, 9.0, 0.0, 'Dinner', 'Small', 'Korean', 'Home Cooked', 'With Boyfriend'),
('1/29/24', 'Egg roll, Mandu, Chicken Wing', 9.0, 8.0, -1.0, 'Snack', 'Medium', 'Chinese', 'Take Out', 'With Boyfriend'),
('1/30/24', 'Steak & Bon Appetea Fried Fishcake', 8.0, 5.0, -3.0, 'Dinner', 'Large', 'Taiwanese', 'Take Out', 'With Boyfriend'),
('1/31/24', 'Udon Noodle Soup & Cucumbers', 8.0, 10.0, 2.0, 'Lunch', 'Medium', 'Chinese', 'Home Cooked', 'With Boyfriend'),
('1/31/24', 'Kimchi Jiggae', 7.0, 8.0, 1.0, 'Dinner', 'Medium', 'Korean', 'Home Cooked', 'With Boyfriend'),
('2/1/24', 'Cucumber Salad', 5.0, 7.0, 2.0, 'Lunch', 'Medium', 'Chinese', 'Home Cooked', 'With Boyfriend'),
('2/1/24', 'Kimchi Jiggae', 8.0, 9.0, 1.0, 'Dinner', 'Medium', 'Korean', 'Home Cooked', 'With Boyfriend'),
('2/2/24', 'Kimchi Jiggae', 6.0, 6.0, 0.0, 'Lunch', 'Small', 'Korean', 'Home Cooked', 'With Boyfriend'),
('2/3/24', 'Jolibee Spicy Chicken', 7.0, 7.0, 0.0, 'Dinner', 'Large', 'Chinese', 'Take Out', 'With Boyfriend'),
('2/4/24', 'McDonald', 8.0, 6.0, -2.0, 'Dinner', 'Medium', 'American', 'Take Out', 'With Boyfriend'),
('2/5/24', 'Magic Milk Boba + cookies', 8.0, 9.0, 1.0, 'Snack', 'Small', 'Taiwanese', 'Restaurant', 'With Friends'),
('2/6/24', 'Salmon Sashimi + Cucumber Salad', 6.0, 10.0, 4.0, 'Dinner', 'Medium', 'Japanese', 'Home Cooked', 'With Boyfriend'),
('2/7/24', 'Salmon Poke Salad', 7.0, 7.0, 0.0, 'Lunch', 'Medium', 'Japanese', 'Take Out', 'With Friends'),
('2/7/24', 'WingStop Wings & Fries', 8.0, 5.0, -3.0, 'Dinner', 'Medium', 'American', 'Take Out', 'With Boyfriend'),
('2/8/24', 'Honey & Hive Acai Bowl', 6.0, 7.0, 1.0, 'Lunch', 'Medium', 'American', 'Restaurant', 'With Boyfriend'),
('2/8/24', 'Mediterannian Plate', 8.0, 6.0, -2.0, 'Dinner', 'Medium', 'Mediterannian', 'Restaurant', 'With Boyfriend'),
('2/9/24', 'Chinese New Year Dinner (Fish, Chicken, etc)', 9.0, 10.0, 1.0, 'Dinner', 'Large', 'Chinese', 'Home Cooked', 'With Family'),
('2/10/24', 'Shrimp & Rice', 5.0, 6.0, 1.0, 'Lunch', 'Medium', 'Chinese', 'Home Cooked', 'Alone'),
('2/11/24', 'Baekjeong Korean BBQ', 9.0, 10.0, 1.0, 'Dinner', 'Large', 'Korean', 'Restaurant', 'With Family'),
('2/11/24', 'Icecream', 9.0, 9.0, 0.0, 'Snack', 'Small', 'Japanese', 'Take Out', 'Alone'),
('2/12/24', 'Naengmyun', 7.0, 8.0, 1.0, 'Lunch', 'Medium', 'Korean', 'Home Cooked', 'With Boyfriend'),
('2/12/24', 'HAKO Pork Cheese Cutlet Curry', 9.0, 7.5, -1.5, 'Dinner', 'Medium', 'Japanese', 'Restaurant', 'With Boyfriend'),
('2/13/24', 'Sprouts Sandwich', 7.0, 7.0, 0.0, 'Lunch', 'Small', 'American', 'Take Out', 'With Boyfriend'),
('2/13/24', 'With Love Icecream', 7.0, 8.0, 1.0, 'Snack', 'Small', 'Japanese', 'Take Out', 'With Boyfriend'),
('2/13/24', 'Golden Deli Pho', 6.0, 8.0, 2.0, 'Dinner', 'Small', 'Vietnamese', 'Take Out', 'With Family'),
('2/14/24', 'Sprouts Salad', 4.0, 5.0, 1.0, 'Lunch', 'Medium', 'American', 'Home Cooked', 'With Boyfriend'),
('2/14/24', 'Kura Sushi', 3.0, 4.0, 1.0, 'Dinner', 'Large', 'Japanese', 'Restaurant', 'With Boyfriend'),
('2/15/24', 'Edamame & Potato Croquette', 5.0, 4.0, -1.0, 'Lunch', 'Small', 'Japanese', 'Take Out', 'With Boyfriend'),
('2/15/24', 'Sprouts Salad', 2.0, 2.0, 0.0, 'Dinner', 'Medium', 'American', 'Take Out', 'With Boyfriend'),
('2/15/24', 'Chocolate Covered Strawberries', 8.0, 9.0, 1.0, 'Snack', 'Small', 'American', 'Home Cooked', 'With Boyfriend'),
('2/16/24', 'Tony\'s Pizza Slice (Chicken Alfredo)', 6.0, 7.0, 1.0, 'Lunch', 'Medium', 'American', 'Take Out', 'With Boyfriend'),
('2/17/24', 'WingStop Wings & Fries', 7.0, 6.0, -1.0, 'Dinner', 'Medium', 'American', 'Take Out', 'With Boyfriend'),
('2/18/24', 'McDonald', 6.0, 6.0, 0.0, 'Dinner', 'Small', 'American', 'Take Out', 'With Boyfriend'),
('2/19/24', 'Kura Sushi', 9.0, 10.0, 1.0, 'Dinner', 'Small', 'Japanese', 'Restaurant', 'With Boyfriend'),
('2/20/24', 'Shin Ramen', 8.0, 7.0, -1.0, 'Dinner', 'Medium', 'Korean', 'Home Cooked', 'With Boyfriend'),
('2/21/24', 'Curry Crab with Rice', 9.0, 7.0, -2.0, 'Dinner', 'Large', 'Chinese', 'Home Cooked', 'With Family'),
('2/22/24', 'Steak Sandwich', 8.0, 10.0, 2.0, 'Lunch', 'Medium', 'American', 'Restaurant', 'With Boyfriend'),
('2/22/24', 'McDonald', 3.0, 5.0, 2.0, 'Dinner', 'Small', 'American', 'Take Out', 'Alone'),
('2/23/24', 'BCD Tofu House', 4.0, 8.0, 4.0, 'Dinner', 'Large', 'Korean', 'Restaurant', 'With Family'),
('2/24/24', 'McDonald McDouble', 5.0, 6.0, 1.0, 'Lunch', 'Small', 'American', 'Take Out', 'Alone'),
('2/24/24', 'XinJiang Skewers & Cucumber Salad', 7.0, 7.0, 0.0, 'Dinner', 'Medium', 'Chinese', 'Restaurant', 'With Boyfriend'),
('2/25/24', 'ONO Hawaiian BBQ Plate ', 9.0, 7.0, -2.0, 'Dinner', 'Small', 'Hawaiian', 'Restaurant', 'With Boyfriend'),
('2/26/24', 'Korean Pear', 8.0, 8.0, 0.0, 'Snack', 'Small', 'Korean', 'Home Cooked', 'With Family'),
('2/26/24', 'Tomato, Egg, & Beef Rice + Steamed Egg ', 7.0, 5.0, -2.0, 'Dinner', 'Medium', 'Chinese', 'Home Cooked', 'With Family'),
('2/27/24', 'AYCE Momo Hotpot', 7.0, 6.0, -1.0, 'Dinner', 'Large', 'Japanese', 'Restaurant', 'With Family'),
('2/28/24', 'Egg & Tomato, Egg, & Beef Rice ', 6.0, 7.0, 1.0, 'Lunch', 'Small', 'Chinese', 'Home Cooked', 'Alone'),
('2/28/24', 'Sun Nong Don', 4.0, 6.0, 2.0, 'Dinner', 'Large', 'Korean', 'Restaurant', 'With Family'),
('2/29/24', 'Eggs & Pork Chop Rice', 9.0, 8.0, -1.0, 'Lunch', 'Small', 'Chinese', 'Take Out', 'Alone'),
('2/29/24', 'Fish Soup, Chinese Fried Rice, Pork Intestine', 7.0, 8.0, 1.0, 'Dinner', 'Large', 'Chinese', 'Restaurant', 'With Family'),
('3/1/24', 'Eggs & Sausage', 7.0, 8.0, 1.0, 'Lunch', 'Small', 'American', 'Home Cooked', 'Alone'),
('3/1/24', 'Chicken Ceaser Salad', 9.0, 10.0, 1.0, 'Dinner', 'Medium', 'American', 'Home Cooked', 'Alone'),
('3/2/24', 'Chicken Ceaser Salad', 9.0, 10.0, 1.0, 'Dinner', 'Medium', 'American', 'Home Cooked', 'Alone'),
('3/3/24', 'Skewers', 8.0, 10.0, 2.0, 'Dinner', 'Small', 'Chinese', 'Restaurant', 'With Family'),
('3/4/24', 'Popcorn Chicken Rice', 5.0, 8.0, 3.0, 'Dinner', 'Medium', 'Taiwanese', 'Take Out', 'With Boyfriend'),
('3/5/24', 'Steamed Crab with Rice', 4.0, 7.0, 3.0, 'Dinner', 'Large', 'Chinese', 'Home Cooked', 'With Boyfriend'),
('3/6/24', 'Shin Ramen Instant Noodles', 7.0, 6.0, -1.0, 'Dinner', 'Small', 'Korean', 'Home Cooked', 'With Boyfriend'),
('3/7/24', 'McDonald Chicken Nuggets', 9.0, 7.0, -2.0, 'Lunch', 'Medium', 'American', 'Restaurant', 'With Boyfriend'),
('3/8/24', 'Marinated Raw Crab', 8.0, 10.0, 2.0, 'Dinner', 'Large', 'Korean', 'Restaurant', 'With Family'),
('3/9/24', 'Chicken Alfredo Pasta', 7.0, 8.0, 1.0, 'Dinner', 'Large', 'American', 'Home Cooked', 'With Boyfriend'),
('3/10/24', 'Jolibee Regular Chicken', 9.0, 7.0, -2.0, 'Dinner', 'Large', 'Chinese', 'Take Out', 'With Boyfriend'),
('3/11/24', 'Shin Ramen Instant Noodles', 7.0, 7.0, 0.0, 'Lunch', 'Medium', 'Korean', 'Home Cooked', 'With Boyfriend'),
('3/12/24', 'Universal Studios Luigi Burger', 7.0, 10.0, 3.0, 'Lunch', 'Medium', 'American', 'Restaurant', 'With Boyfriend'),
('3/13/24', 'Egg Salad Salad', 6.0, 6.0, 0.0, 'Lunch', 'Small', 'Japanese', 'Home Cooked', 'With Boyfriend'),
('3/14/24', 'Berry Pancake', 5.0, 7.0, 2.0, 'Breakfast', 'Medium', 'American', 'Restaurant', 'With Friends'),
('3/15/24', 'AYCE Sushi', 7.0, 9.0, 2.0, 'Dinner', 'Large', 'Japanese', 'Restaurant', 'With Friends'),
('3/16/24', 'McDonald Cheeseburger', 6.0, 7.0, 1.0, 'Dinner', 'Medium', 'American', 'Take Out', 'With Boyfriend'),
('3/17/24', 'Clam Chowder', 8.0, 9.0, 1.0, 'Lunch', 'Large', 'American', 'Restaurant', 'With Boyfriend'),
('3/18/24', 'Fruit Tart', 9.0, 10.0, 1.0, 'Snack', 'Small', 'Chinese', 'Restaurant', 'With Boyfriend'),
('3/19/24', 'Sushi', 9.0, 9.0, 0.0, 'Dinner', 'Large', 'Japanese', 'Restaurant', 'With Boyfriend'),
('3/20/24', 'Salmon Egg Benedict', 8.0, 10.0, 2.0, 'Lunch', 'Medium', 'American', 'Restaurant', 'With Friends'),
('3/21/24', 'German Hot Dog', 9.0, 7.0, -2.0, 'Lunch', 'Small', 'American', 'Restaurant', 'With Friends'),
('3/22/24', 'Tonkatsu Ramen', 8.0, 10.0, 2.0, 'Dinner', 'Medium', 'Japanese', 'Restaurant', 'With Friends'),
('3/23/24', 'Fried Chicken with Fries', 10.0, 9.0, -1.0, 'Dinner', 'Large', 'Japanese', 'Restaurant', 'With Friends'),
('3/24/24', 'McDonald', 4.0, 5.0, 1.0, 'Dinner', 'Large', 'American', 'Restaurant', 'With Boyfriend'),
('3/25/24', 'Bulkdak Ramen', 7.0, 8.0, 1.0, 'Lunch', 'Medium', 'Korean', 'Home Cooked', 'With Boyfriend'),
('3/26/24', 'Pepperoni Pizza', 8.0, 10.0, 2.0, 'Dinner', 'Medium', 'American', 'Take Out', 'With Friends'),
('3/27/24', 'Boba Milk Tea', 5.0, 9.0, 4.0, 'Snack', 'Small', 'Taiwanese', 'Restaurant', 'With Friends'),
('3/28/24', 'Chicken Wings', 7.0, 10.0, 3.0, 'Snack', 'Small', 'Chinese', 'Restaurant', 'With Friends'),
('3/29/24', 'Biang Biang Noodles', 8.0, 10.0, 2.0, 'Lunch', 'Medium', 'Chinese', 'Restaurant', 'With Friends'),
('3/30/24', 'Fish & Chips', 7.0, 9.0, 2.0, 'Lunch', 'Medium', 'American', 'Restaurant', 'With Boyfriend'),
('3/31/24', 'Grilled Cheese', 7.0, 5.0, -2.0, 'Lunch', 'Medium', 'American', 'Take Out', 'With Friends'),
('4/1/24', 'Oysters & Mussels', 8.0, 10.0, 2.0, 'Lunch', 'Large', 'American', 'Restaurant', 'With Friends'),
('4/2/24', 'Buldak Ramen', 3.0, 6.0, 3.0, 'Dinner', 'Medium', 'Korean', 'Home Cooked', 'With Boyfriend'),
('4/3/24', 'Chicken Wings', 8.0, 6.0, -2.0, 'Lunch', 'Medium', 'American', 'Home Cooked', 'With Boyfriend'),
('4/4/24', 'Ribeye Steak', 5.0, 8.0, 3.0, 'Dinner', 'Medium', 'American', 'Home Cooked', 'With Boyfriend'),
('4/5/24', 'Salmon Avocado Rice Bowl', 6.0, 10.0, 4.0, 'Dinner', 'Medium', 'Japanese', 'Home Cooked', 'With Boyfriend'),
('4/6/24', 'Seafood Boil', 8.0, 10.0, 2.0, 'Dinner', 'Medium', 'American', 'Restaurant', 'With Family'),
('4/7/24', 'Sushi Izakaya', 10.0, 10.0, 0.0, 'Dinner', 'Medium', 'Japanese', 'Restaurant', 'With Family'),
('4/8/24', 'Buldak Ramen', 9.0, 10.0, 1.0, 'Dinner', 'Medium', 'Korean', 'Home Cooked', 'With Boyfriend'),
('4/9/24', 'Ribeye Steak', 3.0, 6.0, 3.0, 'Dinner', 'Medium', 'American', 'Home Cooked', 'With Boyfriend'),
('4/10/24', 'McDonald', 7.0, 8.0, 1.0, 'Lunch', 'Medium', 'American', 'Take Out', 'With Boyfriend'),
('4/11/24', 'Dim Sum', 5.0, 7.0, 2.0, 'Lunch', 'Small', 'Chinese', 'Take Out', 'With Family'),
('4/12/24', 'Salmon & Mackeral Sushi', 8.0, 7.0, -1.0, 'Dinner', 'Large', 'Japanese', 'Home Cooked', 'With Boyfriend'),
('4/13/24', 'Pepperoni Pizza', 8.0, 10.0, 2.0, 'Dinner', 'Medium', 'American', 'Take Out', 'With Boyfriend'),
('4/14/24', 'Korean Fried Chicken', 8.0, 10.0, 2.0, 'Dinner', 'Small', 'Korean', 'Restaurant', 'With Family'),
('4/15/24', 'Kimchi Jiggae', 4.0, 5.0, 1.0, 'Dinner', 'Small', 'Korean', 'Home Cooked', 'With Boyfriend');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
