확인

테이블 (14)

diet

  • id — notnull — 기본 키 — NOT NULL
  • user_id — notnull
  • breakfact_meal_id — notnull
  • lunch_meal_id — notnull
  • snack_meal_id — notnull
  • dinner_meal_id — notnull
  • diet_date — VARCHAR(255)
  • diet_name — notnull
  • created_at — notnull
  • updated_at — notnull

exercise

  • id — bigint — 기본 키 — NOT NULL
  • 운동명 (name) — VARCHAR(30)
  • MET 값 (met_value) — VARCHAR(255)
  • created_at — timestamp
  • updated_at — timestamp

exercise_detail

  • id — notnull — 기본 키 — NOT NULL
  • user_id — notnull
  • exercise_id — notnull
  • repetition_num — VARCHAR(255)
  • weight_kg — VARCHAR(255)
  • weight_num — VARCHAR(255)
  • distance — VARCHAR(255)
  • exercise_time — notnull
  • created_at — notnull
  • updated_at — notnull

exercise_detail_collection

  • id — notnull — 기본 키 — NOT NULL
  • user_id — notnull
  • exercise_id — notnull
  • exercise_detail_id — notnull
  • exercise_intensity — notnull
  • created_at — notnull
  • updated_at — notnull

exercise_record

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • exercise_routine_id — bigint — 외래 키 → exercise_routine.user_id — NOT NULL
  • 운동날짜 (exercise_date) — String(8), Date
  • created_at — notnull
  • updated_at — notnull

exercise_routine (excercise_routine)

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • 루틴명 (name) — varchar(50)
  • 생성날짜 (created_at) — timestamp
  • 수정날짜 (updated_at) — timestamp

exercise_routine_detail

  • id — bigint — 기본 키 — NOT NULL
  • exercise_routine_id — bigint — 외래 키 → exercise_routine.id — NOT NULL
  • exercise_id — bigint — 외래 키 → exercise.id — NOT NULL
  • 시간 (time) — int
  • 강도 (intensity) — ENUM('loose', 'normal', 'tight')
  • 상세기록 (detail) — VARCHAR(1000)
  • 우선순위 (priority)

exercise_set (Untitled)

  • id — bigint — 기본 키 — NOT NULL
  • exercise_routine_detail — bigint — 외래 키 → exercise_routine_detail.id — NOT NULL
  • 횟수 (cnt) — int(nullable)
  • 무게 (weight) — int(nullable)
  • 거리 (Field) — int(nullable)
  • 순서 (order) — int

food

  • id — NOT — 기본 키 — NOT NULL
  • calorie — VARCHAR(255)
  • unit — notnull
  • unit_num — notnull
  • carbohydrate_g — VARCHAR(255)
  • protein_g — VARCHAR(255)
  • fat_g — VARCHAR(255)
  • created_at — notnull
  • updated_at — notnull
  • user_id — notnull

food_quantity

  • id — notnull — 기본 키 — NOT NULL
  • meal_id — notnull
  • food_id — notnull
  • quantity — notnull
  • created_at — notnull
  • updated_at — notnull

meal

  • id — notnull — 기본 키 — NOT NULL
  • user_id — notnull
  • food_list_id — notnull
  • created_at — notnull
  • updated_at — notnull

user

  • id — bigint — 기본 키 — NOT NULL
  • 닉네임 (nickname) — varchar(30) — NOT NULL
  • 비밀번호 (password) — varchar(100) — NOT NULL
  • 이메일 (email) — varchar(30) — NOT NULL
  • 성별 (gender) — varchar(10) — NOT NULL
  • 나이 (age) — bigint — NOT NULL
  • 키 (height) — bigint — NOT NULL
  • 목표체중 (target_weight) — double — NOT NULL
  • 생성날짜 (created_at) — DATETIME — NOT NULL
  • 수정날짜 (updated_at) — DATETIME — NOT NULL

user_information

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • has_diet_experience — boolean — NOT NULL
  • diet_fail_reason — varchar(30)
  • appetite_type — varchar(30) — NOT NULL
  • weekly_eating_out_count — int
  • eating_out_type — varchar(30)
  • diet_velocity — int

weight

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • created_at — notnull
  • udpated_at — notnull