.. _results_transit_data_model:

**results** table structure
===========================

The *results* table holds the metadata for results stored in
*results_database.sqlite*.

The **table_name** field presents the actual name of the result
table in *results_database.sqlite*.

The **procedure** field holds the name the the procedure that generated
the result (e.g.: Traffic Assignment).

The **procedure_id** field holds an unique UUID identifier for this procedure,
which is created at runtime.

The **procedure_report** field holds the output of the complete procedure report.

The **timestamp** field holds the information when the procedure was executed.

The **description** field holds the user-provided description of the result.

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

   table_name*,TEXT,NO,
   procedure,TEXT,NO,
   procedure_id,TEXT,NO,
   procedure_report,TEXT,NO,
   timestamp,DATETIME,YES,current_timestamp
   description,TEXT,YES,


(* - Primary key)



The SQL statement for table and index creation is below.


::

   
   
   create TABLE if not exists results (table_name       TEXT     NOT NULL PRIMARY KEY,
                                       procedure        TEXT     NOT NULL,
                                       procedure_id     TEXT     NOT NULL,
                                       procedure_report TEXT     NOT NULL,
                                       timestamp        DATETIME DEFAULT current_timestamp,
                                       description      TEXT);