Skip to main content
`Ctrl`+`K`

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