FundraiserEmail

Primary Key

Primary Key	Field Type
ID	int

Fields

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

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_FundraiserEmail_FundraisersID	FundraisersID
PK_FundraiserEmail	ID	yes	yes	yes

Triggers

Trigger Name	Description
TR_FundraiserEmails_CASCDE_DEL_1