electricity grid transmission table structure

electricity grid transmission table structure#

Provides the transmission buses in the region. It is linked to A-LEAF by providing aggregating electricity demand to it.

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

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

Transmission_Bus_ID*

INTEGER

NO

Primary integer key representing the transmission bus available in the model region

name

TEXT

YES

‘’

Text description of the transmission bus ID if one exists

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS "Electricity_Grid_Transmission"(
    "Transmission_Bus_ID" INTEGER NOT NULL PRIMARY KEY,
    "name"                TEXT DEFAULT ''
);