ev charging station pricing table structure

ev charging station pricing table structure#

Provides ability to vary charging costs by hour of day on a per EVCS basis. It is linked to the EV_Charging_Stations table through a foreign key on station_id.

Not required by all models and is okay to be empty.

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

station_id

INTEGER

NO

EV_Charging_Stations(station_id)

Foreign key reference to an electric vehicle charging station found in the EV_Charging_Station table

time_hour

INTEGER

NO

The hour in the day to express the time-varying cost of charging

unit_price

REAL

NO

the cost (in dollars) per kWh expressed

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS "EV_Charging_Station_Pricing"(
    station_id INTEGER NOT NULL,
    time_hour  INTEGER NOT NULL,
    unit_price REAL    NOT NULL,

    CONSTRAINT "fk_stat_id" FOREIGN KEY("station_id") REFERENCES EV_Charging_Stations("ID") ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
);