vehicle class table structure

This table defines the various classes of vehicles which can exist within a POLARIS simulation. It defines physical characteristics of the vehicles such as their size, acceleration and braking.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
class_id*	INTEGER	NO			The unique identifier of this class
class_type	TEXT	NO	‘’		A text based description (human friendly)
capacity	INTEGER	NO	0		Vehicle carrying capacity - not used by POLARIS
length	REAL	YES	0		Length of a typical vehicle (units: meters)
max_speed	REAL	YES	0		Maximum speed of vehicles of this class (units: m/s)
max_accel	REAL	YES	0		Maximum acceleration of vehicles of this class (units: m/s^2)
max_decel	REAL	YES	0		Maximum braking capacity of vehicles of this class (units: m/s^2)
ev_ml_class	INTEGER	NO	0		The corresponding class ID within the Tensorflow model for battery consumption (Wh/mile)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Vehicle_Class" (
  "class_id" INTEGER NOT NULL PRIMARY KEY,
  "class_type" TEXT NOT NULL DEFAULT '',
  "capacity" INTEGER NOT NULL DEFAULT 0,
  "length" REAL NULL DEFAULT 0,
  "max_speed" REAL NULL DEFAULT 0,
  "max_accel" REAL NULL DEFAULT 0,
  "max_decel" REAL NULL DEFAULT 0,
  "ev_ml_class" INTEGER NOT NULL DEFAULT 0
)