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