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