개인 맞춤형 다이어트 플래너

테이블 (7)

P_AI_FEEDBACK

  • feedback_id — INT
  • user_id — INT
  • feedback_date — DATE
  • feedback_type — ENUM('diet', 'exercise')
  • message — TEXT

P_DIET_PLAN

  • diet_id — INT
  • user_id — INT
  • meal_type — ENUM('breakfast', 'lunch', 'dinner', 'snack')
  • food_items — TEXT
  • total_calories — INT
  • plan_date — DATE

P_EXERCISE_LOG

  • exercise_log_id — INT
  • user_id — INT
  • exercise_name — VARCHAR(100)
  • duration_minutes — INT
  • calories_burned — INT
  • log_date — DATE

P_EXERCISE_PLAN

  • exercise_id — INT
  • user_id — INT
  • exercise_name — VARCHAR(100)
  • duration_minutes — INT
  • calories_burned — INT
  • plan_date — DATE

P_FOOD_LOG

  • log_id — INT
  • user_id — INT
  • log_date — DATE
  • food_name — VARCHAR(100)
  • calories — INT
  • quantity — INT

P_USER

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • age — INT
  • gender — ENUM('M', 'F') — NOT NULL
  • height_cm — FLOAT
  • weight_kg — FLOAT
  • goal_weight_kg — FLOAT
  • activity_level — ENUM('low', 'medium', 'high')

P_WEIGHT_TRACK

  • track_id — INT
  • user_id — INT
  • record_date — DATE
  • weight_kg — FLOAT