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
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