NetAccount

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
DisplayName	nvarchar(255)
EmailAddress	nvarchar(255)
CreateDate	datetime		Default = getutcdate()
UpdateDate	datetime		Default = getutcdate()
LockedOut	bit	yes	Default = 0
LockedDate	datetime	yes
Deleted	bit		Default = 0
DeletedDate	datetime	yes
EmailForwardingEnabled	bit		Default = 1
UserPageURL	nvarchar(255)	yes
OnlineStatus	int		Default = 0
OnlineStatusPreferenceType	int		Default = 0
OnlineStatusUpdateDate	datetime	yes
ProfileImageID	int		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ClientUsersID	int	yes	ClientUsers.ID
LockedUserID	int	yes	ClientUsers.ID
DeletedUserID	int	yes	ClientUsers.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_NetAccount_1	Deleted, LockedOut, ID, ClientUsersID, DisplayName, EmailAddress
IX_NetAccount_ID_DisplayName_Deleted	ID, DisplayName, Deleted
IX_NetAccount_ID_DisplayName_Deleted_ClientUsersID	ID, DisplayName, Deleted, ClientUsersID
IX_NetAccount_ID_DisplayName_LockedOut	ID, DisplayName, LockedOut
IX_NetAccount_ID_DisplayName_OnlineStatus_Deleted	ID, DisplayName, OnlineStatus, Deleted
IX_NetAccount_ID_DisplayName_UpdateDate_Deleted	ID, DisplayName, UpdateDate, Deleted
PK_NetAccount	ID	yes	yes

Referenced by

Referenced by	Field
Message	OwnerID
Message	SenderID
Message	RecipientID
MessageFolder	NetAccountID
NetAccountRelation	NetAccountID
NetAccountRelation	RelationAccountID
NetAccountRelation	BlockedID
NetGroup	NetAccountID
NetGroupRelation	NetAccountID
NetGroupRelation	BlockedID