electricity provider pricing table structure

electricity provider pricing table structure#

Provides ability to vary electricity costs by flexible time periods for each utility. It is linked to the Electricity_Provider table through a fk on station_id. unit_price is the cost per kWh for certain types of pricing, and cost overall for others expressed in dollars

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

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

id*

INTEGER

NO

Primary key referencing the pricing strategy used

Provider_ID

INTEGER

NO

Electricity_Provider(Provider_ID)

Foreign key to electricity provider who is enforcing pricing strategy

type

TEXT

NO

Type of pricing strategy enforced. Can be one of THE ENUM IS THIS< BUT IT IS NOT WORKING @Electricity_Pricing_Type@

start_seconds

INTEGER

NO

Simulation time (in seconds) that the pricing strategy starts being enforced

end_seconds

INTEGER

NO

Simulation time (in seconds) that the pricing strategy stops being enforced

unit_price

REAL

NO

Cost (in $) as applied by the type suggested above

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS "Electricity_Provider_Pricing"(
    id INTEGER NOT NULL PRIMARY KEY,
    Provider_ID INTEGER NOT NULL,
    "type" TEXT NOT NULL,
    start_seconds INTEGER NOT NULL,
    end_seconds INTEGER NOT NULL,
    unit_price REAL NOT NULL,
    CONSTRAINT "fk_prov_id" FOREIGN KEY("Provider_ID") REFERENCES Electricity_Provider("Provider_ID") ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
);