vehicle table structure

Vehicle table holds records for all vehicles simulated in POLARIS. This includes household-owned vehicles as well as fleet-owned vehicles.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
vehicle_id*	INTEGER	NO			Unique identifier of this vehicle
hhold	INTEGER	NO	0		Household to which this vehicle belongs. Negative values represent that the vehicle is fleet-owned. (foreign key to the Household table)
parking	INTEGER	NO	0		Not used
L3_wtp	INTEGER	NO	0		Not used
L4_wtp	INTEGER	NO	0		Not used
type	INTEGER	NO		Vehicle_Type(type)	Vehicle characteristics (foreign key to the Vehicle_Type table)
fleet	INTEGER	YES		Fleet(fleet)	Fleet the vehicle belongs to, if any
subtype	INTEGER	NO	0		Not used

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Vehicle" (
  "vehicle_id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  "hhold" INTEGER NOT NULL DEFAULT 0,
  "parking" INTEGER NOT NULL DEFAULT 0,
  "L3_wtp" INTEGER NOT NULL DEFAULT 0,
  "L4_wtp" INTEGER NOT NULL DEFAULT 0,
  "type" INTEGER NOT NULL,
  "fleet" INTEGER NULL,
  "subtype" INTEGER NOT NULL DEFAULT 0,

  CONSTRAINT "type_fk"
    FOREIGN KEY ("type")
    REFERENCES "Vehicle_Type" ("type_id")
    DEFERRABLE INITIALLY DEFERRED,
  CONSTRAINT "fleet_fk"
    FOREIGN KEY ("fleet")
    REFERENCES "Fleet" ("fleet")
    DEFERRABLE INITIALLY DEFERRED);