Message

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
ParentMessageID	int	yes
Subject	nvarchar(255)	yes
Message	ntext	yes
CreateDate	datetime		Default = getutcdate()
UpdateDate	datetime		Default = getutcdate()
Sent	bit		Default = 0
SentDate	datetime	yes
Deleted	bit		Default = 0
DeletedDate	datetime	yes
Viewed	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
OwnerID	int		NetAccount.ID
SenderID	int		NetAccount.ID
RecipientID	int	yes	NetAccount.ID
MessageFolderID	int	yes	MessageFolder.ID
RecipientGroupID	int	yes	NetGroup.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_Message_ID	ID			yes
IX_Message_ID_OwnerID_SenderID_RecipientID_Deleted_Sent_MessageFolderID	ID, OwnerID, SenderID, RecipientID, Deleted, Sent, MessageFolderID
IX_Message_OwnerID_Recipientid_Deleted_Sent_MessagefolderID_Createdate_Viewed	OwnerID, RecipientID, Deleted, Sent, MessageFolderID, CreateDate, Viewed
PK_Message	ID	yes	yes