| Primary Key | Field Type |
|---|---|
 ID |
int |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 Type |
tinyint | Default = 0 | ||
| Subject |
nvarchar(255) |  |
||
| Message |
ntext | |
||
| Closing |
nvarchar(1000) | |
||
| CreateDate |
datetime | Default = getutcdate() |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 FundRaiserSolicitorsID |
int | FundRaiserSolicitors.ID | ||
| EmailJobID |
int | |
EmailJob.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_FundraiserSolicitorEmail_FundraiserSolicitorsID_EmailJobID |
FundRaiserSolicitorsID, EmailJobID | |||
| IX_FundraiserSolicitorEmail_ID_EmailJobID |
ID, EmailJobID | |||
| PK_FundraiserSolicitorEmail |
ID | |
|
|
| Referenced by | Field |
|---|---|
 FundraiserSolicitorContactAction |
FundRaiserSolicitorEmailID |