Test

Tables (6)

route_points

  • point_id — BIGINT
  • route_id — BIGINT — Foreign key → walk_routes.route_id — NOT NULL
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • sequence — INT — NOT NULL

themes

  • theme_id — BIGINT
  • theme_name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255)
  • color_code — VARCHAR(20)
  • icon_url — VARCHAR(255)

users

  • user_id — BIGINT
  • nickname — VARCHAR(50) — NOT NULL

walk_requests

  • request_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • theme_id — BIGINT — Foreign key → themes.theme_id — NOT NULL
  • requested_time — INT — NOT NULL
  • created_at — TIMESTAMP

walk_routes

  • route_id — BIGINT
  • request_id — BIGINT — Foreign key → walk_requests.request_id — NOT NULL
  • route_name — VARCHAR(100)
  • total_distance — INT
  • estimated_time — INT
  • thumbnail_url — VARCHAR(255)

walk_sessions

  • session_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • route_id — BIGINT — Foreign key → walk_routes.route_id — NOT NULL
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP
  • actual_distance — INT
  • actual_duration — INT