개인 맞춤형 다이어트 플래너
테이블 (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