ClientDonations

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
ClientsID	int
OwnerID	int
Deleted	bit		Default = 0
Guid	uniqueidentifier		Default = (newid())
ConstitCodeID	int	yes
EmailTemplateID	int	yes
DonationOptions	int		Default = 129
TributeOptions	ntext	yes
RedirectPageID	int	yes
NoMGPledges	bit	yes
Attributes	ntext	yes
DonateBtn	nvarchar(100)	yes
RecurrenceOptions	ntext	yes
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	yes
ECardSendDateAttributeID	int	yes
ECardRecipientFirstNameAttributeID	int	yes
ECardRecipientLastNameAttributeID	int	yes
RecurrenceOptionsTruePledge	ntext	yes
CartSendDonationAcknowledgementAlways	bit		Default = 0
MinimumGiftAmount	numeric(30, 6)	yes
MinimumPledgePaymentAmount	numeric(30, 6)	yes
ShowPledgePaymentDueDate	bit		Default = 0
AcknowledgementBlock	nvarchar(max)	yes
AllowSpouseInfo	bit		Default = 0
IncludeChallengeMatch	bit		Default = 0
ChallengeMatchIntro	nvarchar(max)	yes
ChallengeMatch	nvarchar(max)	yes
ImpactStatementTypeID	uniqueidentifier	yes
AppealHistoryQueryID	int		Default = 0
WelcomeEmailTemplateID	int	yes	Default = NULL

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_ClientDonations_GUID_OwnerID_Deleted	Guid, OwnerID, Deleted
PK_ClientDonations	ID	yes	yes	yes

Referenced by

Referenced by	Field
DonationDesignations	ClientDonationsID
DonationGivingLevels	ClientDonationsID
DonationSources	ClientDonationsID
ECardPart	ClientDonationsID