about model table structure

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.

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