groupagents

550 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AgentID INT 10 √ null
GroupID INT 10 null
SearchID INT 10 null
Name VARCHAR 200 null
CheckAction INT 10 null
AlertAction INT 10 null
AlertMessage TEXT 65535 null
ContactID INT 10 null
contactsmultifactorsecurity.ContactId Implied ConstraintR
interval INT 10 null
Where VARCHAR 255 null
What VARCHAR 255 null
DataOut TEXT 65535 null
Comparor INT 10 null
DataIn VARCHAR 8000 null
IDField VARCHAR 500 null
AlertStyle INT 10 0
ScriptID INT 10 null
DataCollector VARCHAR 255 null
Category INT 10 null
TicketCategory INT 10 null
ScriptTarget INT 10 √ 1
GUID VARCHAR 36 √ null
scripttime.Guid Implied ConstraintR
UpdatedBy VARCHAR 50 √ null
UpdateDate DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc AgentID
ContactID Performance Asc ContactID
GroupID Performance Asc GroupID
Name Performance Asc Name
SearchID Performance Asc SearchID

Relationships

Close relationships within degrees of separation