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