Open topic with navigation

NetGroup (4.0SP19)

no changes

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Referenced by

Primary Key
Primary Key	Field Type
ID	int

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
NetAccountID	int	true	NetAccount.ID
ClientRolesID	int	true	ClientRoles.ID
DeletedUserID	int	true	ClientUsers.ID
LockedUserID	int	true	ClientUsers.ID

Fields
Field	Field Type	Null	Notes	Description
DisplayName	nvarchar(100)	false
Description	nvarchar(900)	false
CreateDate	datetime	false	getutcdate()
UpdateDate	datetime	false	getutcdate()
Deleted	bit	false	0
DeletedDate	datetime	true
GroupImageID	int	true
LockedOut	bit	true
LockedDate	datetime	true
ShortDescription	nvarchar(100)	true
MemberApproval	int	true
PublishInDirectory	bit	true
InvitationOption	int	true

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_NetGroup_ID_DisplayName_Deleted_PublishInDirectory	ID DisplayName Deleted PublishInDirectory	False	False	False
PK_NetGroup	ID	True	True	False

Referenced by
Referenced by	Field
Message	RecipientGroupID
NetGroupRelation	NetGroupID