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.

Table Structure

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 charged as $ per kWh 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
);