FundraiserSolicitorEmail

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
Type	tinyint		Default = 0
Subject	nvarchar(255)	yes
Message	ntext	yes
Closing	nvarchar(1000)	yes
CreateDate	datetime		Default = getutcdate()

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
FundRaiserSolicitorsID	int		FundRaiserSolicitors.ID
EmailJobID	int	yes	EmailJob.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_FundraiserSolicitorEmail_FundraiserSolicitorsID_EmailJobID	FundRaiserSolicitorsID, EmailJobID
IX_FundraiserSolicitorEmail_ID_EmailJobID	ID, EmailJobID
PK_FundraiserSolicitorEmail	ID	yes	yes	yes

Referenced by

Referenced by	Field
FundraiserSolicitorContactAction	FundRaiserSolicitorEmailID