Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 Name nvarchar(255)
 Description nvarchar(255)
 OwnerID int  
 Deleted bit   Default = 0
 Guid uniqueidentifier   Default = (newid())
 Type tinyint   Default = 0
 Status tinyint
 ContentHTML ntext
 ContentText ntext
 FromAddress nvarchar(255)
 FromDisplayName nvarchar(255)
 Subject nvarchar(255)
 Priority int
 ReplyAddress nvarchar(255)
 ReturnReceipt bit   Default = 0
 ReturnReceiptAddress nvarchar(255)
 ForwardDSN bit   Default = 0
 ForwardDSNAddress nvarchar(255)
 SendAfterDate datetime   Default = getutcdate()
 CreateDate datetime   Default = getutcdate()
 ProjectAppealListEmailID int
 ParentEmailID int
 AppealID int

Foreign Key Field Type Null Notes Description
 EmailTemplateID int   EmailTemplate.ID
 ClientSitesID int ClientSites.ID

Index Name Field(s) Unique Primary Clustered
 IX_EMAIL__GUID_DELETED_OWNERID Guid, Deleted, OwnerID      
 IX_Email_ID_EmailTemplateID_Subject ID, EmailTemplateID, Subject      
 IX_Email_ParentEmailID ParentEmailID      
 PK_Email ID

Referenced by Field
 Email_EmailList EmailID
 Email_Recipient EmailID
 EmailConditionBlock EmailID
 EmailJob EmailID
 EmailJob_Recipient EmailID
 EmailJobStatus EmailID
 EMAILTESTADDRESSES EMAILID
 FAFEVENTEMAIL EMAILID
 RealmEmail EmailID

Entity-Relationship diagram of this table