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));