1
테이블 (7)
Daily_Log (daily_log)
- log_id — bigint — 기본 키 — NOT NULL
- user_id — bigint — 외래 키 → User(유저).user_id — NOT NULL
- date — timestamp
- TDEE — double
- activity_level — int(1)
Exercise (exercise)
- exercise_id — bigint — 기본 키 — NOT NULL
- exercise_name — varchar(20)
- muscle_group — varchar(20)
- intensity_level — int(1)
Exercise_Log (exercise_log)
- exercise_log_id — bigint — 기본 키 — NOT NULL
- log_id — bigint — 외래 키 → Daily_Log.log_id — NOT NULL
- exercise_id — bigint — 외래 키 → Exercise.exercise_id — NOT NULL
- duration_min — int(10)
- sets_reps — int(10)
Food(음식) (food_per_100g)
- food_id — bigint — 기본 키 — NOT NULL
- food_name — varchar(20)
- price — int(10)
- calories — double
- protein — double
- fat — double
- carbohydrate — double
Food_Log (food_log)
- food_log_id — bigint — 기본 키 — NOT NULL
- log_id — bigint — 외래 키 → Daily_Log.log_id — NOT NULL
- food_id — bigint — 외래 키 → Food(음식).food_id — NOT NULL
- meal_type — varchar(20)
- quantity — double
Recommend_Log (recommend_log)
- Recommend_log — bigint — 기본 키 — NOT NULL
- log_id — bigint — 외래 키 → Daily_Log.log_id — NOT NULL
- recommend_food — varchar(20)
- recommend_exercise — varchar(20)
User(유저) (users)
- user_id — bigint — 기본 키 — NOT NULL
- name — varchar(20)
- age — int(10)
- gender — char(1)
- interest — varchar(20)
- height — double
- weight — double
- target_weight — double
- BMR — double