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.

Field	Type	NULL allowed	Default Value
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);