sixpack

Tables (7)

Condition (컨디션)

  • id (Key) — Primary key — NOT NULL
  • condition (Field) — enum {BEST, GOOD, FAIR, POOR}
  • pain (Field2) — enum {NONE, MILD, SEVERE}
  • created_at (Field3)

PlanRule (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • condition (Field)
  • pain (Field2)
  • target_distance (Field3)
  • min_pace (Field4)
  • max_pace (Field5)
  • headline (Field6)
  • guidance (Field7)

RunSegment (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • session_id (Key2) — Foreign key → RunSession.id — NOT NULL
  • order_no (Field)
  • segment_distance (Field2)
  • pace (Field3)
  • status (Field4) — enum {SLOW, HOLD, FAST}
  • lat (위도)
  • lng (경도)
  • created_at (Field5)

RunSession (러닝세션)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • condition_id (Key4) — Foreign key → Condition.id — NOT NULL
  • plan_rule_id (Key5) — Foreign key → PlanRule.id — NOT NULL
  • state (Field) — enum {DRAFT, IN_PROGRESS, COMPLETED, CANCELLED, PAUSED}
  • total_distance (Field4)
  • total_duration (Field3)
  • avg_pace (Field5)
  • avg_cadence (Field6)
  • pace_score (Field7)
  • warmup_status (Field8)
  • started_at (Field2)
  • ended_at (Field9)

User (유저)

  • id (Key) — Primary key — NOT NULL
  • streak_days (Field)

WeeklyRunning (Untitled)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • week_start_date (Field)
  • running_cnt (Field2)
  • total_distance (Field3)
  • total_duration (Field4)
  • avg_pace (Field5)
  • avg_cadence (Field6)
  • stretch_count (Field7)
  • pain_count (Field8)

XP (Xp)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • session_id (Key3) — Foreign key → RunSession.id — NOT NULL
  • reason (Field) — enum {WARMUP, RUNNING}
  • xp_amount (Field2)
  • created_at (Field3)