EXPERIMENT

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

Column Descriptions:

NameTypeDescription
EXPERIMENT_IDINTEGER NOT NULLReserved for IBM internal use.
NAMEVARCHAR (64) NOT NULLReserved for IBM internal use.
LASTUPDATETIMESTAMP NOT NULLReserved for IBM internal use.
STOREENT_IDINTEGER NOT NULLReserved for IBM internal use.
EXPTYPE_IDINTEGER NOT NULLReserved for IBM internal use.
PRIORITYSMALLINT NOT NULL DEFAULT 1Reserved for IBM internal use.
EXPIRECOUNTINTEGERReserved for IBM internal use.
STARTDATETIMESTAMP NOT NULLReserved for IBM internal use.
ENDDATETIMESTAMPReserved for IBM internal use.
RESULTSCOPECHAR (1) NOT NULLReserved for IBM internal use.
PREFERREDELEMENTSMALLINTReserved for IBM internal use.
STATUSCHAR (1) NOT NULL DEFAULT 'A'Reserved for IBM internal use.
FIELD1INTEGERReserved for IBM internal use.
FIELD2BIGINTReserved for IBM internal use.
FIELD3DECIMAL (20,5)Reserved for IBM internal use.
FIELD4VARCHAR (254)Reserved for IBM internal use.
DESCRIPTIONVARCHAR (254)Reserved for IBM internal use.
LASTUPDATEDBYVARCHAR (254) NOT NULLReserved for IBM internal use.
RULEXMLCLOB (1000000)Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EXPERIMENT_IDPrimary Key
I0001500NAME+STOREENT_IDUnique Index
I0001501STOREENT_ID+STATUSNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1500STOREENT_IDSTOREENTSTOREENT_IDCascade
F_1501EXPTYPE_IDEXPTYPEEXPTYPE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1502EXPERIMENT_IDEXPRESULTEXPERIMENT_IDCascade