Primary Key Field Type
 EventTransactionsID int

Field Field Type Null Notes Description
 ClientEventsID int  
 DateAdded datetime   Default = getutcdate()
 XMLObjectData ntext  
 processed_date datetime
 IsDeleted bit   Default = 0
 EmailID int
 GiftAmount numeric(30, 6)
 GiftPaymentMethod int
 GiftCurrencyType int
 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_EventTransactions_AddedByUserID AddedByUserID      
 IX_EventTransactions_ClientEventsID ClientEventsID      
 IX_EventTransactions_EmailID_IsDeleted EmailID, IsDeleted      
 IX_EventTransactions_EmailJobRecipientID EmailJobRecipientID      
 IX_EventTransactions_Processed_Date processed_date      
 IX_EventTransactions_processed_date_ClientEventsID_IsDeleted processed_date, ClientEventsID, IsDeleted      
 PK_EventTransactions EventTransactionsID

Referenced by Field
 EventItemCapacity EventTransactionsID
 FundRaiserEventRegistrations EventTransactionsID

Entity-Relationship diagram of this table