Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 ClientsID int  
 Name nvarchar(184)
 Description nvarchar(255)
 OwnerID int  
 Deleted bit   Default = 0
 Guid uniqueidentifier   Default = (newid())
 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)
 Type tinyint   Default = 0
 IsInternalUse bit   Default = 0
 DataSourceID int   Default = 0
 CopySourceID int
 CopyBatchGUID uniqueidentifier
 AppealID int

Foreign Key Field Type Null Notes Description
 ClientSitesID int ClientSites.ID
 EXPORTDEFINITIONID uniqueidentifier EXPORTDEFINITION.ID

Index Name Field(s) Unique Primary Clustered
 IX_EmailTemplate_GUID_OwnerID_Deleted Guid, OwnerID, Deleted      
 IX_EmailTemplate_ID_CLientsID_Name ID, ClientsID, Name      
 PK_EmailTemplate ID
 UIX_EmailTemplate_Name ClientSitesID, Type, Name    

Referenced by Field
 ACTIONITEMMESSAGETEXT EMAILTEMPLATEID
 ChapterEmail EmailTemplateID
 ECardPart EmailTemplateID
 Email EmailTemplateID
 EMAILSCHEDULE EMAILTEMPLATEID
 EmailTemplate_EmailList EmailTemplateID
 EmailTemplateConditionBlock EmailTemplateID
 EMAILTEMPLATEEXTENSION EMAILTEMPLATEID
 EVENTEMAILTEMPLATE EMAILTEMPLATEID
 FundraiserEmail EmailTemplateID
 NC_Notification EmailTemplateID

Entity-Relationship diagram of this table