Primary Key Field Type
 DonationTransactionsID int

Field Field Type Null Notes Description
 ClientDonationsID int
 DateAdded datetime   Default = getutcdate()
 XMLObjectData ntext  
 processed_date datetime
 IsDeleted bit   Default = 0
 ClientsID int  
 EmailID int
 GiftAmount numeric(30, 6)
 GiftPaymentMethod int
 GiftCurrencyType int
 LastName nvarchar(256)
 TransactionGUID uniqueidentifier
 Status tinyint   Default = 1
 FailureData nvarchar(max)

Foreign Key Field Type Null Notes Description
 AddedByUserID int ClientUsers.ID
 EmailJobRecipientID int EmailJob_Recipient.ID

Index Name Field(s) 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

Referenced by Field
 ContentComparisonDonationTransactions DonationTransactionID
 DonationEReceipt DonationTransactionsID
 FundRaiserDonations DonationTransactionsID

Entity-Relationship diagram of this table