nyumnyum_db

Tables (3)

diet_records

  • id (Key) — INT — Primary key — NOT NULL
  • id (Key2) — INT — Foreign key → foods.id — NOT NULL
  • id (Key3) — VARCHAR(50) — Foreign key → users.id — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • food_id — INT — NOT NULL
  • meal_date — DATE — NOT NULL
  • meal_type — ENUM('BREAKFAST','LUNCH','DINNER','SNACK') — NOT NULL
  • serving — DECIMAL(6,2)
  • created_at — DATETIME
  • INDEX — idx_dr_user_date

foods

  • id (Key) — INT — Primary key — NOT NULL
  • food_name — VARCHAR(100) — NOT NULL
  • calorie — DECIMAL(7,2)
  • protein — DECIMAL(7,2)
  • carbs — DECIMAL(7,2)
  • fat — DECIMAL(7,2)
  • created_at — DATETIME

users

  • id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • birth_date — DATE
  • gender — ENUM('M','F','OTHER')
  • height_cm — DECIMAL(5,2)
  • weight_kg — DECIMAL(5,2)
  • weekly_exercise — TINYINT
  • exercise_type — VARCHAR(100)
  • weekly_drinking — TINYINT
  • drinking_amount — TINYINT
  • smoking_status — VARCHAR(50)
  • daily_smoking — TINYINT
  • created_at — DATETIME