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