Table: ViewLicenseUsage

This is a view data table which is used by Scout Enterprise Dashboard. The table is filled automatically. It is highly recommended not to change any entry.

ColumnName DataType Key Not Null Default Value Comment
ViewLicenseUsageID INTEGER IDENTITY (1,1) PK NN    
Name NVARCHAR(255)   NN    
Type INTEGER   NN    
Used INTEGER   NN    
Available INTEGER   NN    
Without INTEGER   NN    
Modified DATETIME   NN    
IndexName IndexType Columns
PRIMARY PRIMARY ViewLicenseUsageID

 

How to create

CREATE TABLE ViewLicenseUsage(
ViewLicenseUsageId INTEGER IDENTITY (1,1) NOT NULL,
Name NVARCHAR(255) NOT NULL,
Type INTEGER NOT NULL, Used INTEGER NOT NULL,
Available INTEGER NOT NULL,
Without INTEGER NOT NULL,
Modified DATETIME NOT NULL,
CONSTRAINT PK_ViewLicenseUsage
PRIMARY KEY (ViewLicenseUsageId));