EmailTemplate

Primary Key

Primary Key	Field Type
ID	int

Field	Field Type	Null	Notes
ClientsID	int
Name	nvarchar(184)	yes
Description	nvarchar(255)	yes
OwnerID	int
Deleted	bit		Default = 0
Guid	uniqueidentifier		Default = (newid())
ContentHTML	ntext	yes
ContentText	ntext	yes
FromAddress	nvarchar(255)	yes
FromDisplayName	nvarchar(255)	yes
Subject	nvarchar(4000)	yes
Priority	int	yes
ReplyAddress	nvarchar(255)	yes
ReturnReceipt	bit		Default = 0
ReturnReceiptAddress	nvarchar(255)	yes
ForwardDSN	bit		Default = 0
ForwardDSNAddress	nvarchar(255)	yes
Type	tinyint		Default = 0
IsInternalUse	bit		Default = 0
DataSourceID	int		Default = 0
CopySourceID	int	yes
CopyBatchGUID	uniqueidentifier	yes
AppealID	int	yes
IsSample	bit		Default = 0
EmailAddressTypeID	uniqueidentifier	yes
InactiveRecipientFromMonths	int	yes	Default = 0
IsExcludeInactiveRecipient	bit	yes	Default = 0
AlternateSubject	nvarchar(255)	yes	Default = NULL

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

Index Name	Fields	Unique	Primary	Clustered
IX_EmailTemplate_GUID_OwnerID_Deleted	Guid, OwnerID, Deleted
IX_EmailTemplate_ID_CLientsID_Name	ID, ClientsID, Name
PK_EmailTemplate	ID	yes	yes	yes
UIX_EmailTemplate_Name	ClientSitesID, Type, Name	yes

Referenced by	Field
ACTIONITEMMESSAGETEXT	EMAILTEMPLATEID
ChapterEmail	EmailTemplateID
COMBINATION_MICROSITEEMAILTEMPLATE	EMAILTEMPLATEID
DESIGNATION_MICROSITEEMAILTEMPLATE	EMAILTEMPLATEID
ECardPart	EmailTemplateID
Email	EmailTemplateID
EMAILSCHEDULE	EMAILTEMPLATEID
EmailTemplate_EmailList	EmailTemplateID
EmailTemplateConditionBlock	EmailTemplateID
EMAILTEMPLATEEXTENSION	EMAILTEMPLATEID
EVENT_MICROSITEEMAILTEMPLATE	EMAILTEMPLATEID
EVENTEMAILTEMPLATE	EMAILTEMPLATEID
FundraiserEmail	EmailTemplateID
MEMBERSHIPLEVEL_MICROSITEEMAILTEMPLATE	EMAILTEMPLATEID
MEMBERSHIPPROGRAM_MICROSITEEMAILTEMPLATE	EMAILTEMPLATEID
NC_Notification	EmailTemplateID
PROGRAM_MICROSITEEMAILTEMPLATE	EMAILTEMPLATEID