mastergroups

185 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GroupID INT 10 √ null
ParentID INT 10 null
Parents TEXT 65535 null
Children TEXT 65535 null
depth INT 10 null
Name VARCHAR 50 null
FullName VARCHAR 2048 null
Permissions INT 10 null
Template INT 10 null
AutoJoinScript INT 10 null
Master INT 10 0
LimitToParent INT 10 0
Control INT 10 0
ControlID INT 10 0
Notes VARCHAR 1024 null
MaintenanceID INT 10 null
maintenancewindow.MaintenanceID Implied ConstraintR
MaintWindowApplied DATETIME 19 null
GroupType INT 10 null
Priority INT 10 5
ticketpriority.Priority Implied ConstraintR
GUID VARCHAR 36 null
scripttime.Guid Implied ConstraintR
assetID INT 10 √ null
NetworkPermissions INT 10 √ null
NetworkJoin INT 10 √ null
NetworkJoinOptions INT 10 √ null
ContactPermissions INT 10 √ null
ContactJoin INT 10 √ null
ContactJoinOptions INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc GroupID
AutoJoinScript Performance Asc AutoJoinScript
Control Performance Asc Control
ControlID Performance Asc ControlID
depth Performance Asc depth
GroupType Performance Asc GroupType
GUID Must be unique Asc GUID
Master Performance Asc Master
Name Performance Asc Name
ParentID Performance Asc ParentID
Permissions Performance Asc Permissions
Template Performance Asc Template

Relationships

Close relationships within degrees of separation