데이터베이스응용

테이블 (7)

DailyReport

  • report_id — INT — 기본 키
  • user_id — INT — 외래 키 → User.user_id
  • date — DATE — NOT NULL
  • total_calories — FLOAT
  • total_protein — FLOAT
  • total_fat — FLOAT
  • total_carbs — FLOAT
  • burned_calories — FLOAT
  • net_calories — FLOAT
  • analysis_summary — TEXT

ExerciseLog

  • exercise_id — INT — 기본 키
  • user_id — INT — 외래 키 → User.user_id
  • date — DATE — NOT NULL
  • exercise_name — VARCHAR(100) — NOT NULL
  • duration_min — FLOAT
  • calories_burned — FLOAT
  • intensity — ENUM('low', 'medium', 'high')

Food

  • food_id — INT — 기본 키
  • food_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50)
  • serving_size — FLOAT
  • calories — FLOAT
  • protein — FLOAT
  • fat — FLOAT
  • carbs — FLOAT
  • source — ENUM('user', 'ai', 'official')
  • image_url — VARCHAR(255)

MealLog

  • meal_id — INT — 기본 키
  • user_id — INT — 외래 키 → User.user_id
  • food_id — INT — 외래 키 → Food.food_id
  • date — DATE — NOT NULL
  • meal_type — ENUM('breakfast', 'lunch', 'dinner', 'snack') — NOT NULL
  • quantity — FLOAT
  • photo_url — VARCHAR(255)
  • analyzed — BOOLEAN

User

  • user_id — INT — 기본 키
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • gender — ENUM('M', 'F')
  • birth_date — DATE
  • height — FLOAT
  • current_weight — FLOAT
  • target_weight — FLOAT
  • activity_level — ENUM('low', 'moderate', 'high')
  • created_at — DATETIME

WeeklyReport

  • week_id — INT — 기본 키
  • user_id — INT — 외래 키 → User.user_id
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • avg_calories — FLOAT
  • avg_burned — FLOAT
  • avg_weight — FLOAT
  • goal_feedback — TEXT

WeightLog

  • log_id — INT — 기본 키
  • user_id — INT — 외래 키 → User.user_id
  • date — DATE — NOT NULL
  • weight — FLOAT