about model table structure#
This table holds metadata about the freight model data, it has the same structure as the similarly named tables in the network/demands databases.
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 ''
);