ChapterEmail

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
ChapterSiteID	int
CreateDate	datetime		Default = getutcdate()
UpdateDate	datetime		Default = getutcdate()
Deleted	bit		Default = 0
DisplayName	nvarchar(255)	yes

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_ChapterEmail_ChapterSiteID	ChapterSiteID
PK_ChapterEmail	ID	yes	yes	yes