eatwise

Tables (9)

Auth

  • auth_id — BIGINT
  • user_id — BIGINT
  • email — VARCHAR(255)
  • verification_code — VARCHAR(100)
  • expires_at — DATETIME
  • verified — BOOLEAN

Food

  • food_id — BIGINT
  • food_name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(100)
  • calories — DOUBLE
  • carbs — DOUBLE
  • protein — DOUBLE
  • fat — DOUBLE
  • image_url — VARCHAR(500)

Goal

  • goal_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • daily_calorie_target — DOUBLE
  • carb_ratio — DOUBLE
  • protein_ratio — DOUBLE
  • fat_ratio — DOUBLE
  • start_date — DATE
  • end_date — DATE

MealRecord

  • record_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • food_id — BIGINT — NOT NULL
  • intake_time — DATETIME
  • intake_date — DATE
  • quantity — DOUBLE
  • total_calories — DOUBLE

Notification

  • notification_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • type — VARCHAR(50)
  • message — TEXT
  • created_at — DATETIME
  • read_status — BOOLEAN

RecommendedFood

  • rec_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • food_id — BIGINT — NOT NULL
  • reason — TEXT
  • created_at — DATETIME

Report

  • report_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • report_date — DATE
  • calories_consumed — DOUBLE
  • nutrient_summary — TEXT
  • feedback — TEXT

Restaurant

  • restaurant_id — BIGINT
  • name — VARCHAR(255)
  • address — VARCHAR(255)
  • phone — VARCHAR(50)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • image_url — VARCHAR(500)

User

  • user_id — BIGINT
  • username — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • age — INT
  • gender — VARCHAR(10)
  • height — DOUBLE
  • weight — DOUBLE
  • created_at — DATETIME