FundraiserSolicitorContactAction
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 | ||
| Status | tinyint | yes | ||
| StatusReport | ntext | yes | ||
| ForwardEmailJobRecipientID | int | yes | ||
| ForwardingContactActionID | int | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| FundraiserSolicitorContactID | int | FundraiserSolicitorContact.ID | ||
| AddressbookContactsID | int | AddressBookContacts.ID | ||
| FundraiserSolicitorsID | int | FundRaiserSolicitors.ID | ||
| FundRaiserDonationsID | int | yes | FundRaiserDonations.ID | |
| FundRaiserSolicitorEmailID | int | yes | FundraiserSolicitorEmail.ID | |
| EmailJobRecipientID | int | yes | EmailJob_Recipient.ID | |
| EmailRecipientID | int | yes | Email_Recipient.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_FundraiserSolicitorContactAction_EmailJobRecipientID_EmailRecipientID_FundRaiserSolicitorEmailID | EmailJobRecipientID, EmailRecipientID, FundRaiserSolicitorEmailID | |||
| IX_FundraiserSolicitorContactAction_FSCID_Type | FundraiserSolicitorContactID, Type | |||
| IX_FundraiserSolicitorContactAction_FSID_Type_ID | FundraiserSolicitorsID, Type, ID | |||
| PK_FundraiserSolicitorContactAction | ID | yes | yes | yes |