MembershipTransactions

Primary Key

Primary Key	Field Type
ID	int

Fields

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

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MembershipTransactions_EmailJobRecipientID	EmailJobRecipientID
IX_MembershipTransactions_processed_date_ClientMembershipsID	processed_date, ClientMembershipsID
PK_MembershipTransactions	ID	yes	yes	yes