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)