Open topic with navigation

ClientEvents (4.0SP4)

Primary Key
Primary Key Field Type

ID

int
Foreign Key Fields
Foreign Key Field Type Null Notes Description

ContentID

int

true

MerchantAccount

int

true

ShoppingCartPageID

int

true

Fields
Field Field Type Null Notes Description

ClientsID

int

false

OwnerID

int

false

Deleted

bit

false

0

Guid

uniqueidentifier

false

(newid())

FundID

int

true

ConstitCodeID

int

true

EmailTemplateID

int

true

RedirectPageID

int

true

NoMGPledges

bit

true

CartMessage

ntext

true

AllowCreditCard

bit

false

1

AllowPledge

bit

false

0

CartSendRegistrationAcknowledgementAlways

bit

false

0

AcknowledgementBlock

nvarchar(max)

true

DisplayEventConflictNotification

bit

false

0

Indexes
Index Name Field(s) Unique Primary Clustered

IX_ClientEvents_GUID_OwnerID_Deleted

Guid

OwnerID

Deleted

False

False

False

PK_ClientEvents

ID

True

True

True
Referenced by
Referenced by Field

EventItems

ClientEventsID