관통

테이블 (12)

Authentications

  • authentication_id — INT — 기본 키 — NOT NULL
  • user_id — INT — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

Comments

  • comment_id — INT — 기본 키 — NOT NULL
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

CrewMembers

  • crew_member_id — INT — 기본 키 — NOT NULL
  • crew_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • joined_at — DATETIME — NOT NULL

CrewMessages

  • message_id — INT — 기본 키 — NOT NULL
  • crew_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

Crews

  • crew_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • max_members — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • captain_user_id — INT — NOT NULL

Posts

  • post_id — INT — 기본 키 — NOT NULL
  • user_id — INT — NOT NULL
  • crew_id — INT
  • content — TEXT — NOT NULL
  • image_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

Recommendations

  • recommendation_id — INT — 기본 키 — NOT NULL
  • user_id — INT — NOT NULL
  • route_id — INT — NOT NULL
  • reason — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

Routes

  • route_id — INT — 기본 키 — NOT NULL
  • user_id (user_id2) — INT — 외래 키 → Users.user_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • distance_km — FLOAT — NOT NULL
  • estimated_time_min — INT — NOT NULL
  • start_location — VARCHAR(255) — NOT NULL
  • end_location — VARCHAR(255) — NOT NULL
  • path_data — TEXT
  • created_at — DATETIME — NOT NULL

Runs

  • run_id — INT — 기본 키 — NOT NULL
  • user_id (user_id2) — INT — 외래 키 → Users.user_id — NOT NULL
  • route_id — INT
  • run_date — DATETIME — NOT NULL
  • run_duration_sec — INT — NOT NULL
  • run_distance_km — FLOAT — NOT NULL

Sessions

  • session_id — INT — 기본 키 — NOT NULL
  • user_id (user_id2) — INT — 외래 키 → Users.user_id — NOT NULL
  • session_token — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • expires_at — DATETIME — NOT NULL

UserStats

  • user_stat_id — INT — 기본 키 — NOT NULL
  • user_id — INT — NOT NULL
  • average_speed_kmh — FLOAT — NOT NULL
  • total_run_count — INT — NOT NULL
  • total_run_distance_km — FLOAT — NOT NULL
  • total_run_duration_sec — INT — NOT NULL

Users

  • user_id — INT — 기본 키 — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • profile_image — VARCHAR(255)
  • created_at — DATETIME — NOT NULL