zone tnc ev table structure#
Zone_TNC_EV table shows information of all electric TNC vehicles across the simulation day.
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
|---|---|---|---|---|---|
time |
INTEGER |
NO |
0 |
Simulation time in seconds when EV-related metrics for vehicle is logged to database |
|
tnc_id |
INTEGER |
NO |
0 |
1-based ID for TNC vehicle within a TNC operator |
|
vehicle_id |
INTEGER |
NO |
0 |
Vehicle ID consistent with Vehicle table in Demand |
|
SoC |
REAL |
YES |
0 |
Percentage of energy contained in the battery |
|
charging_trips |
INTEGER |
NO |
0 |
Cumulative count of trips made to charging station |
|
zone |
INTEGER |
NO |
0 |
Zone ID of vehicle at the time when the record is created |
|
id* |
INTEGER |
NO |
Record identifier |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Zone_TNC_EV" (
"time" INTEGER NOT NULL DEFAULT 0,
"tnc_id" INTEGER NOT NULL DEFAULT 0,
"vehicle_id" INTEGER NOT NULL DEFAULT 0,
"SoC" REAL NULL DEFAULT 0,
"charging_trips" INTEGER NOT NULL DEFAULT 0,
"zone" INTEGER NOT NULL DEFAULT 0,
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT)