Scout Database Model (CR)

Table: Entity

March 25, 2025

Contributed by:

The Entries in this table correspond to running Scout components like Scout server and console. Since the entries are created and removed dynamically, it is not recommended to change them.

ColumnName	DataType	Key	Not Null	DefaultValue	Comment
EntityID	INTEGER	PK	NN		Unique ID of entity entry
Type	INTEGER				Entity type
					0 - Scout Server
					1 - Scout Console
Version	NVARCHAR(255)				Entity version
IPAddress	NVARCHAR(255)
StartTime	INTEGER
HostID	NVARCHAR(64)
Username	NVARCHAR(255)
Features	INTEGER
Mode	INTEGER
HeartBeat	INTEGER
Status	INTEGER
Threshold1	INTEGER
Threshold2	INTEGER			90
Threshold3	INTEGER
Threshold4	INTEGER
DatabaseConnections	INTEGER
IPName	NVARCHAR(255)
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER
IccInstanceID	INTEGER
LogFileName	NVARCHAR(255)				Name of log file used by an entity

IndexName	IndexType	Columns
PRIMARY	PRIMARY	EntityID

How to create

    CREATE TABLE Entity(
    EntityID INTEGER NOT NULL,
    Type INTEGER NOT NULL,
    Version NVARCHAR(255),
    IPAddress NVARCHAR(255),
    StartTime INTEGER,
    HostID NVARCHAR(64),
    Username NVARCHAR(255),
    Features INTEGER,
    Mode INTEGER,
    HeartBeat INTEGER,
    Status INTEGER,
    Threshold1 INTEGER,
    Threshold2 INTEGER,
    Threshold3 INTEGER,
    Threshold4 INTEGER,
    ReservedString1 NVARCHAR(255),
    ReservedString2 NVARCHAR(255),
    ReservedInt1 INTEGER,
    ReservedInt2 INTEGER,
    IccInstanceID INTEGER,
    IPName NVARCHAR(255),
    DatabaseConnections INTEGER,
    LogFileName NVARCHAR(255),
    PRIMARY KEY (EntityID));
  

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: Entity

March 25, 2025

Contributed by:

Table: Entity

How to create

In this article