CACHEDDISCOUNTRESULTAPPLICATION

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
INPUTHASH	varbinary
DISCOUNTID	uniqueidentifier
PROGRAMID	uniqueidentifier	yes
EVENTID	uniqueidentifier	yes
PRICETYPECODEID	uniqueidentifier	yes
MERCHANDISEPRODUCTINSTANCEID	uniqueidentifier	yes
AMOUNT	money		Default = 0
NUMBEROFDISCOUNTEDITEMS	smallint		Default = ((0))
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_CACHEDDISCOUNTRESULTAPPLICATION_DATEADDED	DATEADDED			yes
IX_CACHEDDISCOUNTRESULTAPPLICATION_DATECHANGED	DATECHANGED
IX_CACHEDDISCOUNTRESULTAPPLICATION_INPUTHASH_DISCOUNTID	INPUTHASH, DISCOUNTID
PK_CACHEDDISCOUNTRESULTAPPLICATION	ID	yes	yes

Triggers

Trigger Name	Description
TR_CACHEDDISCOUNTRESULTAPPLICATION_AUDIT_UPDATE
TR_CACHEDDISCOUNTRESULTAPPLICATION_AUDIT_DELETE