관통
테이블 (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