ClientDonations (Table)

Primary Key	Field Type
ID	int

Foreign Key	Field Type	Notes
ContentID	int	SiteContent.ID
MerchantAccount	int	ClientMerchantAccounts.ID
ShoppingCartPageID	int	SitePages.ID
ECardPartID	int	ECardPart.ID

Field	Field Type	Notes
ClientsID	int
OwnerID	int
Deleted	bit	Default = 0
Guid	uniqueidentifier	Default = (newid())
ConstitCodeID	int
EmailTemplateID	int
DonationOptions	int	Default = 129
TributeOptions	ntext
RedirectPageID	int
NoMGPledges	bit
Attributes	ntext
DonateBtn	nvarchar(100)
RecurrenceOptions	ntext
EReceiptPdfForCreditCard	bit	Default = 0
EReceiptPdfForDirectDebit	bit	Default = 0
MarkReceiptedForCreditCard	bit	Default = 0
MarkReceiptedForDirectDebit	bit	Default = 0
EReceiptContent	ntext	Default = ('')
EReceiptPdfMargin	int	Default = 20
CartMessage	ntext
ECardSendDateAttributeID	int
ECardRecipientFirstNameAttributeID	int
ECardRecipientLastNameAttributeID	int
RecurrenceOptionsTruePledge	ntext
CartSendDonationAcknowledgementAlways	bit	Default = 0
MinimumGiftAmount	numeric(30, 6)
MinimumPledgePaymentAmount	numeric(30, 6)
ShowPledgePaymentDueDate	bit	Default = 0
AcknowledgementBlock	nvarchar(max)
AllowSpouseInfo	bit	Default = 0
IncludeChallengeMatch	bit	Default = 0
ChallengeMatchIntro	nvarchar(max)
ChallengeMatch	nvarchar(max)
ImpactStatementTypeID	uniqueidentifier
AppealHistoryQueryID	int	Default = 0

Index Name	Field(s)	Unique	Primary	Clustered
IX_ClientDonations_GUID_OwnerID_Deleted	Guid, OwnerID, Deleted
PK_ClientDonations	ID