health mate

Tables (10)

Copy Of users (CopyOf유저)

  • id (식별자) — bigint — Primary key — NOT NULL
  • birth (생일) — varchar
  • email (이메일) — varchar
  • password (비밀번호) — varchar
  • userRole (유저신분) — enum(user, admin)

body_status (몸 상태)

  • id (식별자) — bigint — Primary key — NOT NULL
  • user_id (유저 식별자) — bigint — Foreign key → users.id — NOT NULL
  • muscle_id (근육 식별자) — bigint — Foreign key → muscles.id — NOT NULL
  • status (근육 상태) — int

exercises (운동)

  • id (식별자) — bigint — Primary key — NOT NULL
  • eng_name (영어이름) — varchar
  • kor_name (한국어 이름) — varchar
  • description (설명) — text
  • set (한세트) — enum(timer, count)
  • difficulty (난이도) — enum(easy, medium, hard)
  • equipment (장비) — varchar
  • part (근육 자극받는 부위) — enum(근육)
  • caution (조심할 점) — varchar

monthly_challenge (주간 챌린지)

  • id (식별자) — bigint — Primary key — NOT NULL
  • user_id (유저 식별자) — bigint — Foreign key → users.id — NOT NULL
  • muscle_id (근육 식별자) — bigint — Foreign key → muscles.id — NOT NULL
  • level (레벨) — int
  • best_performance (고점) — int
  • month (월) — int
  • year (연) — int

muscles (근육)

  • id (식별자) — bigint — Primary key — NOT NULL
  • id (식별자2) — bigint — Foreign key → exercises.id — NOT NULL
  • eng_name (영어 이름) — varchar
  • kor_name (한국어 이름) — varchar
  • part (근육 부위) — enum(근육)

routine_exercises (루틴에 포함된 운동)

  • id (식별자) — bigint — Primary key — NOT NULL
  • routine_id (루틴 식별자) — bigint — Foreign key → routines.id — NOT NULL
  • exercise_id (운동 식별자) — bigint — Foreign key → exercises.id — NOT NULL
  • set_number (세트 수) — int
  • count_exercise (횟수) — int
  • time_exercise (시간) — int
  • order_number (운동 순서) — int

routines (운동 루틴)

  • id (식별자) — bigint — Primary key — NOT NULL
  • user_id (유저 식별자) — bigint — Foreign key → users.id — NOT NULL
  • name (루틴 이름) — varchar

users (유저)

  • id (식별자) — bigint — Primary key — NOT NULL
  • birth (생일) — varchar
  • email (이메일) — varchar
  • password (비밀번호) — varchar
  • userRole (유저신분) — enum(user, admin)

weekly_challenge (주간 챌린지2)

  • id (식별자) — bigint — Primary key — NOT NULL
  • level (레벨) — int
  • best_performance (고점) — int
  • month (월) — int
  • year (연) — int

weekly_logs (주간 바디 정보)

  • id (식별자) — bigint — Primary key — NOT NULL
  • user_id (유저 식별자) — bigint — Foreign key → users.id — NOT NULL
  • workout_time (운동 시간) — int
  • body_weight (몸무게) — int
  • body_bmi (체지방) — int
  • spent_calories (소모한 칼로리) — int
  • yearweek (몇년도 몇주차) — varchar