ev features table structure

EV Features table brings together information related to the EV powertrain. EV-related features are especially required in the ML-based consumption model in POLARIS to update battery level during simulation.

It is a static table and is not updated by POLARIS.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
ev_features_id*	INTEGER	NO			unique identifier for this set of EV feature
veh_class	INTEGER	YES		Vehicle_Class(veh_class)	References vehicle class
veh_pwt	INTEGER	YES		Powertrain_Type(veh_pwt)	References vehicle powertrain
veh_fuel	INTEGER	YES		Fuel_Type(veh_fuel)	References vehicle fuel type
veh_autolvl	INTEGER	YES		Automation_Type(veh_autolvl)	References vehicle automation level
veh_vintagelvl	INTEGER	YES		Vintage_Type(veh_vintagelvl)	References vehicle vintage level
veh_mass	REAL	YES	0		The mass of the vehicle (units: kg)
veh_whl_roll1	REAL	YES	0
veh_chas_fa	REAL	YES	0
veh_chas_cd	REAL	YES	0
veh_accelec_pwr	REAL	YES	0
veh_fd_ratio	REAL	YES	0
veh_eng_pwrmax	REAL	YES	0
veh_eng_effmax	REAL	YES	0
veh_mot_pwrmax	REAL	YES	0
veh_mot_effmax	REAL	YES	0
veh_mot2_pwrmax	REAL	YES	0
veh_mot2_effmax	REAL	YES	0
veh_ess_pwrmax	REAL	YES	0
veh_ess_energy	REAL	YES	0		Maximum battery level (units: Wh)
veh_gb_nb	REAL	YES	0
veh_gb_effmax	REAL	YES	0

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "EV_Features" (
  "ev_features_id" INTEGER NOT NULL PRIMARY KEY,
  "veh_class" INTEGER NULL,
  "veh_pwt" INTEGER NULL,
  "veh_fuel" INTEGER NULL,
  "veh_autolvl" INTEGER NULL,
  "veh_vintagelvl" INTEGER NULL,
  "veh_mass" REAL NULL DEFAULT 0,
  "veh_whl_roll1" REAL NULL DEFAULT 0,
  "veh_chas_fa" REAL NULL DEFAULT 0,
  "veh_chas_cd" REAL NULL DEFAULT 0,
  "veh_accelec_pwr" REAL NULL DEFAULT 0,
  "veh_fd_ratio" REAL NULL DEFAULT 0,
  "veh_eng_pwrmax" REAL NULL DEFAULT 0,
  "veh_eng_effmax" REAL NULL DEFAULT 0,
  "veh_mot_pwrmax" REAL NULL DEFAULT 0,
  "veh_mot_effmax" REAL NULL DEFAULT 0,
  "veh_mot2_pwrmax" REAL NULL DEFAULT 0,
  "veh_mot2_effmax" REAL NULL DEFAULT 0,
  "veh_ess_pwrmax" REAL NULL DEFAULT 0,
  "veh_ess_energy" REAL NULL DEFAULT 0,
  "veh_gb_nb" REAL NULL DEFAULT 0,
  "veh_gb_effmax" REAL NULL DEFAULT 0,
  CONSTRAINT "veh_class_fk"
    FOREIGN KEY ("veh_class")
    REFERENCES "Vehicle_Class" ("class_id")
    DEFERRABLE INITIALLY DEFERRED,
  CONSTRAINT "veh_pwt_fk"
    FOREIGN KEY ("veh_pwt")
    REFERENCES "Powertrain_Type" ("type_id")
    DEFERRABLE INITIALLY DEFERRED,
  CONSTRAINT "veh_fuel_fk"
    FOREIGN KEY ("veh_fuel")
    REFERENCES "Fuel_Type" ("type_id")
    DEFERRABLE INITIALLY DEFERRED,
  CONSTRAINT "veh_autolvl_fk"
    FOREIGN KEY ("veh_autolvl")
    REFERENCES "Automation_Type" ("type_id")
    DEFERRABLE INITIALLY DEFERRED,
  CONSTRAINT "veh_vintagelvl_fk"
    FOREIGN KEY ("veh_vintagelvl")
    REFERENCES "Vintage_Type" ("type_id")
    DEFERRABLE INITIALLY DEFERRED)