칼로리워
테이블 (4)
exercises
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- calories_per_five_min — INT — NOT NULL
user_exercises
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- exercise_id — BIGINT — 외래 키 → exercises.id — NOT NULL
- is_selected — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
user_game_status
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- total_score — INT — NOT NULL
- team_color — VARCHAR(7) — NOT NULL
- current_exercise_id — BIGINT — 외래 키 → exercises.id
- is_working — BOOLEAN — NOT NULL
- start_latitude — DOUBLE
- start_longitude — DOUBLE
- updated_at — TIMESTAMP — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL