Primary Key Field Type
 ProfileUpdateTransactionsID int

Field Field Type Null Notes Description
 ClientsID int  
 DateLastChanged datetime   Default = getutcdate()
 XMLObjectData ntext  
 processed_date datetime
 BackOfficeID int
 IsDeleted bit   Default = 0

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

Index Name Field(s) Unique Primary Clustered
 IX_ProfileTransactions_EmailJobRecipientID EmailJobRecipientID      
 IX_ProfileUpdateTransactions_AddedByUserID AddedByUserID      
 IX_ProfileUpdateTransactions_BackOfficeID BackOfficeID      
 IX_ProfileUpdateTransactions_Processed_date_ClientsID_Backofficeid processed_date, ClientsID, BackOfficeID      
 PK_ProfileUpdateTransactions ProfileUpdateTransactionsID

Entity-Relationship diagram of this table