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 — 위치수집시각