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

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