EXPSTATS

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
EXPERIMENT_IDINTEGER NOT NULLReserved for HCL internal use.
TESTELEMENT_IDINTEGER NOT NULLReserved for HCL internal use.
STOREENT_IDINTEGER NOT NULLReserved for HCL internal use.
NAMEVARCHAR (64)Reserved for HCL internal use.
EXPTYPE_IDINTEGERReserved for HCL internal use.
CONTROLELEMENTCHAR (1) NOT NULLReserved for HCL internal use.
DISPLAYSINTEGER DEFAULT 0Reserved for HCL internal use.
CLICKSINTEGER DEFAULT 0Reserved for HCL internal use.
DISPLAYORDERSINTEGER DEFAULT 0Reserved for HCL internal use.
DISPLAYREVENUEDECIMAL (20,5) DEFAULT 0Reserved for HCL internal use.
CLICKORDERSINTEGER DEFAULT 0Reserved for HCL internal use.
CLICKREVENUEDECIMAL (20,5) NOT NULL DEFAULT 0Reserved for HCL internal use.
CURRENCYCHAR (3)Reserved for HCL internal use.
FREQUENCYVARCHAR (10)Reserved for HCL internal use.
FIELD1INTEGERReserved for HCL internal use.
FIELD2BIGINTReserved for HCL internal use.
FIELD3DECIMAL (20,5)Reserved for HCL internal use.
FIELD4VARCHAR (254)Reserved for HCL internal use.
TESTELEMENTNAMEVARCHAR (254) NOT NULLReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EXPERIMENT_ID+TESTELEMENT_ID+STOREENT_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1506EXPTYPE_IDEXPTYPEEXPTYPE_IDCascade