데이터베이스응용
테이블 (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