칼로리워

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