ClientEvents

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())
FundID	int	yes
ConstitCodeID	int	yes
EmailTemplateID	int	yes
RedirectPageID	int	yes
NoMGPledges	bit	yes
CartMessage	ntext	yes
AllowCreditCard	bit		Default = 1
AllowPledge	bit		Default = 0
CartSendRegistrationAcknowledgementAlways	bit		Default = 0
AcknowledgementBlock	nvarchar(max)	yes
DisplayEventConflictNotification	bit		Default = 0
AppealID	int	yes

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_ClientEvents_GUID_OwnerID_Deleted	Guid, OwnerID, Deleted
PK_ClientEvents	ID	yes	yes	yes

Referenced by

Referenced by	Field
EventItems	ClientEventsID