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 (차량번호)