scenarios table structure#

Attributes follow

Field

Type

NULL allowed

Default Value

scenario_name

TEXT

NO

description

TEXT

YES

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS scenarios (scenario_name TEXT UNIQUE NOT NULL, description TEXT);

INSERT INTO 'scenarios' (scenario_name, description) VALUES('root', 'The default, and root, scenario for an AequilbraE project. The name "root" is treated as a special case.');

INSERT INTO 'attributes_documentation' (name_table, attribute, description) VALUES('scenarios', 'scenario_name', 'The scenario folder name.');
INSERT INTO 'attributes_documentation' (name_table, attribute, description) VALUES('scenarios', 'description', 'Description of the scenario');