Scout Database Model (LTSR)

Table: System

March 25, 2025

Contributed by:

System properties are stored as a combination of parameter name and value. It is highly recommended that you do not change any entries.

ColumnName	DataType	Key	Not Null	Comment
SystemID	INTEGER	PK	NN
ParamName	NVARCHAR(255)		NN	Note: From version 15.5.2000 and 15.8, the application role name and password are read from the fields RNameEx and RPassEx. In earlier versions, they were read from RName and RPass.
ParamVal	NVARCHAR(255)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	SystemID

How to create

CREATE TABLE System(
SystemID INTEGER NOT NULL,
ParamName NVARCHAR(255) NOT NULL,
ParamVal NVARCHAR(255) NOT NULL,
PRIMARY KEY (SystemID));
  

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

Table: System

March 25, 2025

Contributed by:

Table: System

How to create

In this article