Table: DynamicClientGroup

ColumnName DataType Key Not Null Default Value Comment
DynamicClientGroupID INTEGER PK NN   Unique ID of Dynamic Client Group entry
Name NVARCHAR(255)       Name of the Dynamic Client Group
Query NVARCHAR(max)       Last filter phrase of the SQL query
CreationDate INTEGER       Creation date of the Dynamic Client Group
ScoutAdmin NVARCHAR(255)       Scout Enterprise administrator who created the Dynamic Client Group
ReservedString1 NVARCHAR(255)        
ReservedString2 NVARCHAR(255)        
ReservedInt1 INTEGER        
ReservedInt2 INTEGER        
IndexName IndexType Columns
PRIMARY PRIMARY DynamicClientGroupID

 

how to create

CREATE TABLE DynamicClientGroup(
DynamicClientGroupID INTEGER NOT NULL,
Name NVARCHAR(255),
Query NVARCHAR(max),
CreationDate INTEGER,
ScoutAdmin NVARCHAR(255),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (DynamicClientGroupID));