NetGroupRelation

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
Confirmation	int		Default = 0
ConfirmationDate	datetime	yes
CreateDate	datetime		Default = getutcdate()
UpdateDate	datetime		Default = getutcdate()

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
NetGroupID	int		NetGroup.ID
NetAccountID	int		NetAccount.ID
BlockedID	int	yes	NetAccount.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_NetGroupRelation_ID_NetGroupID_NetAccountID	ID, NetGroupID, NetAccountID
IX_NetGroupRelation_NetAccountID_NetGroupID_BlockedID	NetAccountID, NetGroupID, BlockedID
IX_NetGroupRelation_NetGroupID_NetAccountID_BlockedID_Confirmation	ID, NetGroupID, NetAccountID, BlockedID, Confirmation
PK_NetGroupRelation	ID	yes	yes