Table: Entity

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