simulator
Tables (7)
Company (Untitled3)
- Id — varchar(50) — Primary key — NOT NULL
Director (Untitled4)
- Id — varchar(50) — Primary key — NOT NULL
- createdTime — date
- companyId — varchar(50)
- vehicleId — varchar(50)
- authority
Driver (Untitled5)
- Key — Primary key — NOT NULL
Microtrip (Untitled7)
- Key — Primary key — NOT NULL
Sensor (Untitled2)
- Id — varchar(50) — Primary key — NOT NULL
- companyId — varchar(50)
- director — varchar(50)
- vehicleId — varchar(50)
- vehicleNo — varchar(50)
- serialNo — varchar(50)
Trip (Untitled6)
- Id — varchar(50) — Primary key — NOT NULL
- vehicleId — varchar(50)
- userId — varchar(50)
- StartTs — date
- StartDt — date
- endTs — date
- endDt — date
- sensorId — varchar(50)
- deviceType
Vehicle (Untitled)
- Id — varchar(50) — Primary key — NOT NULL
- companyId — varchar(50)
- director — varchar(50)
- currentDriverId — varchar(50)
- vehicleNo — varchar(50)
- lat
- lon