shuttleTracker
Tables (5)
friendship
- id — BIGINT — Primary key — NOT NULL
- from_user_id — BIGINT — Foreign key → user.id — NOT NULL — 친구 요청 보낸 사람
- to_user_id — BIGINT — Foreign key → user.id — NOT NULL — 친구 요청 받은 사람
- status — VARCHAR(20) — NOT NULL — PENDING | ACCEPTED | REJECTED
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6)
location_share
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- route_id — BIGINT — Foreign key → shuttle_route.id — 탑승 노선 (선택)
- start_time — DATETIME(6) — NOT NULL — 공유 시작 시간
- end_time — DATETIME(6) — NOT NULL — 공유 종료 시간 (1시간 후)
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6)
shuttle_route
- id — BIGINT — Primary key — NOT NULL
- route_name — VARCHAR(50) — NOT NULL — 예: 1호차, 2호차
- region — VARCHAR(10) — NOT NULL — 서울 | 대전 | 광주 | 구미 | 부울경
- route_number — INT — NOT NULL — 예: 1, 2, 3
- description — VARCHAR(200)
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6)
shuttle_stop
- id — BIGINT — Primary key — NOT NULL
- route_id — BIGINT — Foreign key → shuttle_route.id — NOT NULL
- stop_name — VARCHAR(100) — NOT NULL — 경유지 이름 (예: 구미역, 인동)
- latitude — DECIMAL(9, 6) — NOT NULL — 위도
- longitude — DECIMAL(9, 6) — NOT NULL — 경도
- sequence — INT — NOT NULL — 경유지 순서 (1,2,3...)
- is_terminal — TINYINT(1) — NOT NULL — 종점 여부
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6)
user
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL — BCrypt 암호화 저장
- name — VARCHAR(50) — NOT NULL
- location_share_agree — TINYINT(1) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6)