Unicon documentation migration is in progress. You might find some broken links or experience minor issues in the documentation. We are working on resolving these issues.

X

Scout Database Model (CR)

Table: ViewDatabaseInformation

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
ViewDatabaseInformationID INTEGER IDENTITY (1,1) PK NN    
Source INTEGER   NN    
Name NVARCHAR(255)   NN    
Instance NVARCHAR(255)   NN    
Type INTEGER   NN    
Hostname NVARCHAR(255)   NN    
Version NVARCHAR(10)   NN    
Modified DATETIME   NN    
IndexName IndexType Columns
PRIMARY PRIMARY ViewDatabaseInformationID

How to create

CREATE TABLE ViewDatabaseInformation( ViewDatabaseInformationID INTEGER IDENTITY (1,1) NOT NULL, Source INTEGER NOT NULL, Name NVARCHAR(255) NOT NULL, Instance NVARCHAR(255) NOT NULL, Type INTEGER NOT NULL, Hostname NVARCHAR(255) NOT NULL, Version NVARCHAR(10) NOT NULL, Modified DATETIME NOT NULL, CONSTRAINT PK_ViewDatabaseInformation PRIMARY KEY (ViewDatabaseInformationID));
Table: ViewDatabaseInformation