Table: ViewServerInformation
This is a view data table which is used by Scout Dashboard. The table is filled automatically. It is highly recommended not to change any entry.
ColumnName | DataType | Key | Not Null | Default Value | Comment |
---|---|---|---|---|---|
ViewServerInformationID | INTEGER IDENTITY (1,1) | PK | NN | ||
Name | NVARCHAR(255) | NN | |||
Type | INTEGER | NN | |||
Uptime | DATETIME | NN | |||
Online | BIT | NN | |||
Modified | DATETIME | NN |
IndexName | IndexType | Columns |
---|---|---|
PRIMARY | PRIMARY | ViewConnectedConsoleId |
How to create
CREATE TABLE ViewServerInformation(
ViewServerInformationID INTEGER IDENTITY (1,1) NOT NULL,
Name NVARCHAR(255) NOT NULL,
Type INTEGER NOT NULL,
Uptime DATETIME NOT NULL,
Online BIT NOT NULL,
Modified DATETIME NOT NULL,
CONSTRAINT PK_iewServerInformation
PRIMARY KEY (ViewServerInformationID))