NetAccountRelation

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
NetAccountID	int		NetAccount.ID
RelationAccountID	int		NetAccount.ID
BlockedID	int	yes	NetAccount.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_NetAccountRelation_ID_NetAccountID_RelationAccountID	ID, NetAccountID, RelationAccountID
IX_NetAccountRelation_ID_NetAccountID_RelationAccountID_BlockedID_Confirmation	ID, NetAccountID, RelationAccountID, BlockedID, Confirmation
PK_NetAccountRelation	ID	yes	yes