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