Click or drag to resize
Database Table Param

[This is preliminary documentation and is subject to change.]

This tables holds (name,values) pairs. As such, it can be used for any purpose.

However, in a typical installation, only one (name,value) pair exists in the table.

There must exist one row, where the Name field equals "DataModelVersion". In this row, the Value field holds the data model version number (a text string in the format "<majorversion>.<minorversion>"). A given data model version number identifies a physical database structure (tables, views, functions, stored procedures, etc.)

This value is automatically inserted / updated by the database creation / update procedure - see Creating a new Database.

Do NOT edit these values manually (unless you really know what you are doing). It is of vital importance for the function of the TOPICA framework, that the data model version number corresponds to the actual database objects!

Fields

Field Name

Type

Note

Description

Name

varchar(32)

Primary key

name of parameters

Value

varchar(255)

Primary key

value of parameter