generated evcs table structure

Table contains a list of generated electric vehicle charging stations Records in this table are only generated when using the heuristic in-simulation siting algorithm

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
ID*	INTEGER	NO			Unique identifier of generated/existing electric vehicle charging station
Latitude	REAL	YES	0		Not used
Longitude	REAL	YES	0		Not used
num_plugs_L1	INTEGER	NO	0		Number of Level 1 plugs at charging station with a power rating of about 1000 W
num_plugs_L2	INTEGER	NO	0		Number of Level 2 plugs at charging station with a power rating of about 7000 w
num_plugs_DCFC	INTEGER	NO	0		Number of Direct Current Fast Charging (DCFC) plugs at charging station with a power rating of about 50,000 W
location	INTEGER	NO	0		Location ID from Location table in Supply on where the new charging stations
zone	INTEGER	NO	0		Zone ID from Zone table in Supply on which zone contains the new charging station

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Generated_EVCS" (
  "ID" INTEGER NOT NULL PRIMARY KEY,
  "Latitude" REAL NULL DEFAULT 0,
  "Longitude" REAL NULL DEFAULT 0,
  "num_plugs_L1" INTEGER NOT NULL DEFAULT 0,
  "num_plugs_L2" INTEGER NOT NULL DEFAULT 0,
  "num_plugs_DCFC" INTEGER NOT NULL DEFAULT 0,
  "location" INTEGER NOT NULL DEFAULT 0,
  "zone" INTEGER NOT NULL DEFAULT 0)