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