Primary Key Field Type
 ID int

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

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

Index Name Field(s) Unique Primary Clustered
 IX_ChapterEmail_ChapterSiteID ChapterSiteID      
 PK_ChapterEmail ID

Entity-Relationship diagram of this table