Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 ClientsID int  
 OwnerID int  
 Deleted bit   Default = 0
 Guid uniqueidentifier   Default = (newid())
 FundID int
 ConstitCodeID int
 EmailTemplateID int
 RedirectPageID int
 NoMGPledges bit
 CartMessage ntext
 AllowCreditCard bit   Default = 1
 AllowPledge bit   Default = 0
 CartSendRegistrationAcknowledgementAlways bit   Default = 0
 AcknowledgementBlock nvarchar(max)
 DisplayEventConflictNotification bit   Default = 0

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

Index Name Field(s) Unique Primary Clustered
 IX_ClientEvents_GUID_OwnerID_Deleted Guid, OwnerID, Deleted      
 IX_ClientMemberships_GUID_OwnerID_Deleted Guid, OwnerID, Deleted      
 PK_ClientEvents ID

Referenced by Field
 EventItems ClientEventsID

Entity-Relationship diagram of this table