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!
Field Name | Type | Note | Description |
---|---|---|---|
Name | varchar(32) | Primary key | name of parameters |
Value | varchar(255) | Primary key | value of parameter |