zone charging demand table structure

Table records the average charging demand in each zone at every hour of the day. Values are stored across all operators operating in the simulated region and by hour in day and origin zone.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
zone*	INTEGER	NO			The unique identifier of the zone consistent with the Zone table in Supply database
electric_grid_id	INTEGER	NO	0		Electric id corresponding to the zone
start	INTEGER	NO	0		Simulation time in seconds when data aggregation STARTS
end	INTEGER	NO	0		Simulation time in seconds for when data aggregation ENDS
charging_station_demand_kWh	REAL	YES	0		Electricity demand at EVCS in the specific zone
charging_station_v2g_kWh	REAL	YES	0		Electricity delivered through discharging at EVCs in the specific zone
home_charging_demand_kWh	REAL	YES	0		Home charging demand in the specific zone

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Zone_Charging_Demand" (
  "zone" INTEGER NOT NULL PRIMARY KEY,
  "electric_grid_id" INTEGER NOT NULL DEFAULT 0,
  "start" INTEGER NOT NULL DEFAULT 0,
  "end" INTEGER NOT NULL DEFAULT 0,
  "charging_station_demand_kWh" REAL NULL DEFAULT 0,
  "charging_station_v2g_kWh" REAL NULL DEFAULT 0,
  "home_charging_demand_kWh" REAL NULL DEFAULT 0
  )