.. _scenarios_network_data_model:

**scenarios** table structure
=============================

Attributes follow

.. csv-table:: 
   :header: "Field", "Type", "NULL allowed", "Default Value"
   :widths:    30,     20,         20,          20

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