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