확인
테이블 (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