about model table structure

about model table structure#

This table holds metadata about the demand model data, it has the same structure as the similarly named table in the network database.

This table can be read and written by the read_about_model and write_about_model methods in polaris-studio.

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

infoname*

TEXT

NO

The key used to look up metadata (i.e. “build-date”)

infovalue

TEXT

NO

‘’

The value (actual data) (i.e. “2024-01-24”)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS "About_Model" (
    "infoname"  TEXT NOT NULL PRIMARY KEY,
    "infovalue" TEXT NOT NULL DEFAULT ''
);