메루치

테이블 (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`)