Skip to main content
`Ctrl`+`K`

# about table structure

The about table holds information about the AequilibraE model currently developed.

The infoname field holds the name of information being added

The infovalue field holds the information to add

Field | Type | NULL allowed | Default Value
--- | --- | --- | ---
infoname | TEXT | NO |
infovalue | TEXT | YES |

(* - Primary key)

The SQL statement for table and index creation is below.

    CREATE TABLE  if not exists about (infoname  TEXT UNIQUE NOT NULL,
                                       infovalue TEXT
                                      );
    INSERT INTO 'about' (infoname) VALUES('model_name');

    INSERT INTO 'about' (infoname) VALUES('region');

    INSERT INTO 'about' (infoname) VALUES('description');

    INSERT INTO 'about' (infoname) VALUES('author');

    INSERT INTO 'about' (infoname) VALUES('year');

    INSERT INTO 'about' (infoname) VALUES('scenario_description');

    INSERT INTO 'about' (infoname) VALUES('model_version');

    INSERT INTO 'about' (infoname) VALUES('project_id');

    INSERT INTO 'about' (infoname) VALUES('aequilibrae_version');

    INSERT INTO 'about' (infoname) VALUES('projection');

    INSERT INTO 'about' (infoname) VALUES('driving_side');

    INSERT INTO 'about' (infoname) VALUES('license');

    INSERT INTO 'about' (infoname) VALUES('scenario_name');