electricity provider table structure

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	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
);