Table: ViewLicenseUsage
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 |
---|---|---|---|---|---|
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));