FocusTrain
Tables (9)
focus_sessions
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- status — VARCHAR(20) — NOT NULL — RUNNING/PAUSED/COMPLETED/ABORTED
- started_at — DATETIME(6) — NOT NULL — 목표 진척 컷 기준
- ended_at — DATETIME(6)
- focus_seconds — INT — 원천 데이터 (4 투영)
goals
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- user_id — BIGINT — Foreign key → users.id — 개인 목표 owner (room_id와 XOR)
- mission_id — BIGINT — Foreign key → missions.id — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE/COMPLETED/ABANDONED
- started_at — DATETIME(6) — NOT NULL — 진척 컷 기준
- completed_at — DATETIME(6)
mission_waypoints
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- mission_id — BIGINT — Foreign key → missions.id — NOT NULL
- seq — INT — NOT NULL — 미션 내 순번(1부터)
- name — VARCHAR(50) — NOT NULL
- distance_km — DECIMAL(12, 2) — NOT NULL — 출발점부터 누적거리
missions
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- mode — VARCHAR(20) — NOT NULL — RUNNING/CLIMBING/SPACESHIP
- source_label (start_label) — VARCHAR(50) — NOT NULL
- destination_label — VARCHAR(50) — NOT NULL
- total_distance_km — DECIMAL(12, 2) — NOT NULL — 표시/테마용
- total_target_seconds — INT — NOT NULL — 완주 목표 집중시간(초) - 코어
room_goals
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — DATETIME(6) — NOT NULL
- completed_at — DATETIME(6)
- room_id — BIGINT — Foreign key → rooms.id — NOT NULL
- mission_id — BIGINT — Foreign key → missions.id — NOT NULL
room_users
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- room_id — BIGINT — Foreign key → rooms.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- role — VARCHAR(10) — NOT NULL — OWNER/MEMBER
rooms
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- code — VARCHAR(8) — NOT NULL
session_legs
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- session_id — BIGINT — Foreign key → focus_sessions.id — NOT NULL
- leg_number — INT — NOT NULL
- started_at — DATETIME(6) — NOT NULL
- ended_at — DATETIME(6)
- duration_seconds — INT
users
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- firebase_uid — VARCHAR(128) — NOT NULL — Firebase UID
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL