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)