setinel

Tables (4)

Analysislog (분석 로그)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → LocationLog.LocationLog_id — NOT NULL
  • vehicle_id (차량ID) — Foreign key → LocationLog.vehicle_id — NOT NULL

Driver (운전자)

  • driver_id (운전자id) — Primary key — NOT NULL
  • name (이름)
  • email (이메일)
  • vehicle_id (차량ID) — Foreign key → Vehicle.vehicle_id — NOT NULL

LocationLog (이동 경로)

  • LocationLog_id (이동경로 ID) — Primary key — NOT NULL
  • vehicle_id (차량ID) — Foreign key → Vehicle.vehicle_id — NOT NULL
  • latitude (현재 위도)
  • longitude (현재 경도)
  • target_latitude (목적지 위도)
  • target_longitude (목적지 경도)
  • speed (현재 속도)

Vehicle (차량)

  • vehicle_id (차량ID) — Primary key — NOT NULL
  • vehicle_no (차량번호)