DonationTransactions
Primary Key
| Primary Key | Field Type |
|---|---|
| DonationTransactionsID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientDonationsID | int | yes | ||
| DateAdded | datetime | Default = getutcdate() | ||
| XMLObjectData | ntext | |||
| processed_date | datetime | yes | ||
| IsDeleted | bit | Default = 0 | ||
| ClientsID | int | |||
| EmailID | int | yes | ||
| GiftAmount | numeric(30, 6) | yes | ||
| GiftPaymentMethod | int | yes | ||
| GiftCurrencyType | int | yes | ||
| LastName | nvarchar(256) | yes | ||
| TransactionGUID | uniqueidentifier | yes | ||
| Status | tinyint | Default = 1 | ||
| FailureData | nvarchar(max) | yes | ||
| EmailJobRecipientID | int | yes | ||
| ORDERID | nvarchar(50) | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| AddedByUserID | int | yes | ClientUsers.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_DonationTransactions_AddedByUserID_EmailID_Status | AddedByUserID, EmailID, Status | |||
| IX_DonationTransactions_ClientDonationsID | ClientDonationsID | |||
| IX_DonationTransactions_EmailID_IsDeleted | EmailID, IsDeleted | |||
| IX_DonationTransactions_EmailJobRecipientID | EmailJobRecipientID | |||
| IX_DonationTransactions_ID_processed_date | DonationTransactionsID, processed_date | |||
| IX_DonationTransactions_processed_date_ClientDonationsID_IsDeleted_ClientsID | processed_date, ClientDonationsID, IsDeleted, ClientsID | |||
| PK_DonationTransactions | DonationTransactionsID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| ContentComparisonDonationTransactions | DonationTransactionID |
| DonationEReceipt | DonationTransactionsID |
| FundRaiserDonations | DonationTransactionsID |