electricity provider table structure#
Provides the electric utilities in the region. The associated pricing table provides the type of collection used by utility. Useful in understanding cost of electricity (that is not at the wholesale rate)
Not required by all models and is okay to be empty.
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
---|---|---|---|---|---|
Provider_ID* |
INTEGER |
NO |
Primary key for electric utility in the region |
||
name |
TEXT |
YES |
‘’ |
Name of the electric utility represented |
|
fixed_fee_per_kWh |
REAL |
YES |
0 |
Any fixed fees (in $ / kWh) charged by the utility. More complex pricing schemes stored in Electricity_Provider_Pricing |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE IF NOT EXISTS "Electricity_Provider"(
"Provider_ID" INTEGER NOT NULL PRIMARY KEY,
"name" TEXT DEFAULT '',
"fixed_fee_per_kWh" REAL DEFAULT 0
);