FundraiserSolicitorContact
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 | ||
| EmailAddress | nvarchar(255) | yes | ||
| Appeal | bit | Default = 0 | ||
| Thanks | bit | Default = 0 | ||
| Unsolicited | bit | Default = 0 |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| AddressbookContactsID | int | AddressBookContacts.ID | ||
| FundraiserSolicitorsID | int | FundRaiserSolicitors.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_FundraiserSolicitorContact_FSID_ABID_ID | FundraiserSolicitorsID, AddressbookContactsID, ID | |||
| PK_FundraiserSolicitorContact | ID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| FundraiserSolicitorContactAction | FundraiserSolicitorContactID |