Ghost Runner

Tables (8)

Course

  • id — BIGINT — NOT NULL
  • name — VARCHAR(30) — NOT NULL — 코스 이름
  • distance — FLOAT — NOT NULL — 코스 거리 (m)
  • altitude — INT — NOT NULL — 총 고도 (m)
  • start_location — POINT — NOT NULL — 시작 지점 좌표
  • end_location — POINT — NOT NULL — 끝 지점 좌표
  • path_data — LONGTEXT — NOT NULL — 위치·고도 시퀀스 JSONL
  • created_at — TIMESTAMP — NOT NULL

Event

  • id — BIGINT — NOT NULL
  • course_id — BIGINT — Foreign key → Course.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL

Friendship

  • user_id — BIGINT — NOT NULL
  • friend_id — BIGINT — NOT NULL
  • status — ENUM — NOT NULL
  • requested_at — TIMESTAMP — NOT NULL
  • responded_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

REDIS

  • course:{course_id}:ranking — SORTED_SET — 코스별 유저 랭킹(페이스 기준)
  • token:refresh:{refresh_token} — STRING — JWT 리프레쉬토큰

RunningRecord

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • course_id — BIGINT — Foreign key → Course.id — NOT NULL
  • total_distance — FLOAT — NOT NULL — 총 거리(km)
  • total_altitude — FLOAT — NOT NULL — 총 오른 고도(km)
  • avg_pace — FLOAT — NOT NULL — 평균 페이스 (초/km)
  • calories — INT — NOT NULL — 소모 칼로리
  • avg_cadence — INT — NOT NULL — 평균 케이던스 (spm)
  • avg_bpm — INT — NOT NULL — 평균 심박수 (bpm)
  • started_at — TIMESTAMP — NOT NULL — 러닝 시작 시간
  • duration — INT — NOT NULL — 총 시간 (초)
  • is_public — BOOLEAN — NOT NULL
  • has_paused — BOOLEAN — NOT NULL — 정지 유무
  • pauses_record — TEXT — NOT NULL — 정지한 시간
  • telemetry_s3_url — VARCHAR(2048) — NOT NULL — S3 Presigned URL
  • created_at — TIMESTAMP — NOT NULL

S3

  • 실시간 — 러닝

User

  • id — BIGINT — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_pic_url — VARCHAR(2048)
  • gender — ENUM — 성별(남/여)
  • weight — INT — 몸무게(kg)
  • height — INT — 키(cm)
  • created_at — TIMESTAMP — NOT NULL

UserEvent

  • id — BIGINT — NOT NULL
  • event_id — BIGINT — Foreign key → Event.id — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL