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