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