about model table structure

about model table structure#

This table holds metadata about the model, and it has become a requirement since the introduction of this formal data model for the Polaris network.

This table holds the information on the data model version this network is compatible with, and therefore crucial to not be manually edited by the user

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