EmailProjectAppeal

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
Name	nvarchar(50)	yes
Description	nvarchar(256)	yes
CurrentStep	smallint	yes
Deleted	bit	yes	Default = 0
Guid	uniqueidentifier		Default = (newid())
DuplicateSearchStatus	tinyint		Default = 0
DuplicateSearchStartDate	datetime	yes	Default = getutcdate()
DuplicateSearchedDate	datetime	yes	Default = getutcdate()
DuplicateSearchMsg	ntext	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
EmailProjectID	int	yes	EmailProject.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_EmailProjectAppeal_EmailProjectID	EmailProjectID
IX_EmailProjectAppeal_ProjectID_Name	EmailProjectID, Name	yes
PK_EmailProjectAppeal	ID	yes	yes	yes

Referenced by

Referenced by	Field
EmailProjectAppeal_Duplicates	EmailProjectAppealID
EmailProjectAppeal_EmailList	EmailProjectAppealID