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