T-Sync ERD

Tables (5)

route_stations

  • route_station_id (매팡ID) — BIGSERIAL
  • route_id (노선ID) — VARCHAR(20) — Foreign key → routes.route_id — NOT NULL — 노선ID
  • station_id (정류장ID) — VARCHAR(20) — Foreign key → stations.station_id — NOT NULL — 정류장ID
  • station_sequence (정류장순서) — INTEGER — NOT NULL — 정류장순서

routes

  • route_id (노선ID) — VARCHAR(20)
  • route_no (노선번호) — VARCHAR(100) — NOT NULL — 노선번호
  • route_type (노선유형) — VARCHAR(50) — 노선유형
  • start_stop (기점정류장명) — VARCHAR(100) — 기점정류장명
  • end_stop (종점정류장명) — VARCHAR(100) — 종점정류장명

stations

  • station_id (정류장ID) — VARCHAR(20)
  • station_name (정류장명) — VARCHAR(150) — NOT NULL — 정류장명
  • latitude (위도) — DOUBLE — 위도
  • longitude (경도) — DOUBLE — 경도

transfer_predictions

  • prediction_id (예측결과ID) — BIGSERIAL
  • user_id (사용자식별ID) — VARCHAR(100) — 사용자식별ID
  • vehicle_position_id (참조차량위치ID) — BIGINT — Foreign key → vehicle_positions.vehicle_position_id — NOT NULL — 참조차량위치ID
  • target_route_id (환승대상노선ID) — VARCHAR(20) — Foreign key → routes.route_id — NOT NULL — 환승대상노선ID
  • transfer_station_id (환승정류장ID) — VARCHAR(20) — Foreign key → stations.station_id — 환승예정정류장ID
  • success_probability (환승성공확률) — NUMERIC(5,2) — 환승성공확률(%)
  • is_warning (환승지연/실패경고여부) — BOOLEAN — 환승지연/실패경고여부
  • warning_reason (경고발생원인) — VARCHAR(200) — 경고발생원인
  • predicted_at (예측실행시각) — TIMESTAMP — 예측실행시각

vehicle_positions

  • vehicle_position_id (차량위치ID) — BIGSERIAL
  • vehicle_no (차량번호) — VARCHAR(30) — NOT NULL — 차량번호
  • route_id (노선ID) — VARCHAR(20) — Foreign key → routes.route_id — NOT NULL — 노선ID
  • latitude (차량위도) — DOUBLE — 차량위도
  • longitude (차량경도) — DOUBLE — 차량경도
  • operation_speed (차량속도) — NUMERIC(6,2) — 차량속도
  • operation_direction (차량방향각) — INTEGER — 차량방향각
  • collected_at (위치수집시각) — TIMESTAMP — 위치수집시각