메루치
테이블 (15)
Exercise
- id — INTEGER — 기본 키 — NOT NULL
- name — VARCHAR(191) — NOT NULL
- description — VARCHAR(191) — NOT NULL
- howTo — VARCHAR(191)
- isWeight — BOOLEAN — NOT NULL
- isRepetition — BOOLEAN — NOT NULL
- image — VARCHAR(191)
- videoUrl — VARCHAR(191)
- INDEX — `Exercise_name_idx`(`name`)
Food
- id — INTEGER — 기본 키 — NOT NULL
- foodRecordId — INTEGER — NOT NULL
- foodName — VARCHAR(191) — NOT NULL
- calories — INTEGER — NOT NULL
- proteinGram — INTEGER — NOT NULL
- createdAt — DATETIME(3) — NOT NULL
- INDEX — `Food_foodRecordId_idx`(`foodRecordId`)
FoodRecord
- id — INTEGER — 기본 키 — NOT NULL
- userId — INTEGER — NOT NULL
- intakeDate — DATETIME(3) — NOT NULL
- intakeTime — VARCHAR(191) — NOT NULL
- createdAt — DATETIME(3) — NOT NULL
- photoUrls — VARCHAR(191)
- INDEX — `FoodRecord_userId_idx`(`userId`)
FoodRecordComment
- id — INTEGER — 기본 키 — NOT NULL
- text — VARCHAR(191) — NOT NULL
- userId — INTEGER — NOT NULL
- foodRecordId — INTEGER — NOT NULL
- createdAt — DATETIME(3) — NOT NULL
- INDEX — `FoodRecordComment_userId_idx`(`userId`)
- INDEX — `FoodRecordComment_foodRecordId_idx`(`foodRecordId`)
Lesson
- id — INTEGER — 기본 키 — NOT NULL
- userId — INTEGER — NOT NULL
- trainerId — INTEGER — NOT NULL
- count — INTEGER
- state — VARCHAR(191) — NOT NULL
- isUserConfirm — BOOLEAN — NOT NULL
- isTrainerConfirm — BOOLEAN — NOT NULL
- isComplete — BOOLEAN — NOT NULL
- memo — VARCHAR(191)
- lessonAt — DATETIME(3) — NOT NULL
- createdAt — DATETIME(3) — NOT NULL
- INDEX — `Lesson_userId_idx`(`userId`)
- INDEX — `Lesson_trainerId_idx`(`trainerId`)
Routine
- id — INTEGER — 기본 키 — NOT NULL
- name — VARCHAR(191) — NOT NULL
- isCommon — BOOLEAN — NOT NULL
- createdById — INTEGER — NOT NULL
- INDEX — `Routine_createdById_idx`(`createdById`)
RoutineExercise
- routineId — INTEGER — 기본 키 — NOT NULL
- exerciseId — INTEGER — 기본 키 — NOT NULL
- INDEX — `RoutineExercise_routineId_idx`(`routineId`)
- INDEX — `RoutineExercise_exerciseId_idx`(`exerciseId`)
Set
- id — INTEGER — 기본 키 — NOT NULL
- weight — INTEGER
- repetitions — INTEGER — NOT NULL
- isComplete — BOOLEAN — NOT NULL
- workoutId — INTEGER — NOT NULL
- exerciseId — INTEGER — NOT NULL
- INDEX — `Set_exerciseId_idx`(`exerciseId`)
- INDEX — `Set_workoutId_idx`(`workoutId`)
Trainer
- id — INTEGER — 기본 키 — NOT NULL
- name — VARCHAR(191) — NOT NULL
- email — VARCHAR(191) — NOT NULL
- myUserId — INTEGER — NOT NULL
- isSuper — BOOLEAN — NOT NULL
- isOut — BOOLEAN — NOT NULL
Training
- id — INTEGER — 기본 키 — NOT NULL
- userId — INTEGER — NOT NULL
- isDone — BOOLEAN — NOT NULL
- trainingAt — DATETIME(3) — NOT NULL
- createdAt — DATETIME(3) — NOT NULL
- INDEX — `Training_userId_idx`(`userId`)
User
- id — INTEGER — 기본 키 — NOT NULL
- name — VARCHAR(191) — NOT NULL
- username — VARCHAR(191) — NOT NULL
- email — VARCHAR(191) — NOT NULL
- year — INTEGER
- trainerId — INTEGER
- isTrainer — BOOLEAN — NOT NULL
- recommendCalories — INTEGER
- INDEX — `User_trainerId_idx`(`trainerId`)
UserBody
- id — INTEGER — 기본 키 — NOT NULL
- userId — INTEGER — NOT NULL
- height — DOUBLE
- bmi — DOUBLE
- bodyFat — INTEGER
- type — VARCHAR(191)
- chest — DOUBLE
- shoulder — DOUBLE
- upperArm — DOUBLE
- thigh — DOUBLE
- weight — DOUBLE
- maxWeight — DOUBLE
- minWeight — DOUBLE
- targetWeight — DOUBLE
- targetWeeklyWeight — DOUBLE
- targetCalories — INTEGER
- targetProteinGram — DOUBLE
- experience — VARCHAR(191)
- medicalHistory — VARCHAR(191)
- isGoalBulkUp — VARCHAR(191)
- isGoalLeanMassUp — VARCHAR(191)
- isGoalCutting — VARCHAR(191)
- goalsDesc — VARCHAR(191)
- createdAt — DATETIME(3) — NOT NULL
- INDEX — `UserBody_userId_idx`(`userId`)
Weight
- id — INTEGER — 기본 키 — NOT NULL
- weight — DOUBLE — NOT NULL
- weightAt — DATETIME(3) — NOT NULL
- userId — INTEGER — NOT NULL
- createdAt — DATETIME(3) — NOT NULL
- INDEX — `Weight_userId_idx`(`userId`)
Workout
- id — INTEGER — 기본 키 — NOT NULL
- targetWeight — INTEGER
- targetRepetitions — INTEGER — NOT NULL
- exerciseId — INTEGER — NOT NULL
- trainingId — INTEGER — NOT NULL
- INDEX — `Workout_trainingId_idx`(`trainingId`)
- INDEX — `Workout_exerciseId_idx`(`exerciseId`)
_ExerciseToRoutine
- A — INTEGER — NOT NULL
- B — INTEGER — NOT NULL
- INDEX — `_ExerciseToRoutine_B_index`(`B`)