APPLY_MEMBER

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

Column Descriptions:

NameTypeDescription
SEGMENTATION_IDINTEGER NOT NULLReserved for IBM internal use.
SEGMENT_INDEXINTEGER NOT NULLReserved for IBM internal use.
SCOREDOUBLE NOT NULLReserved for IBM internal use.
MEMBER_IDBIGINT NOT NULLReserved for IBM internal use.
SUB_IDBIGINT NOT NULLReserved for IBM internal use.
TYPE_IDINTEGER NOT NULLReserved for IBM internal use.
CONFIDENCEDOUBLEReserved for IBM internal use.
SCORE2DOUBLEReserved for IBM internal use.
SEGMENT_INDEX2INTEGERReserved for IBM internal use.
LAST_UPDATEDTIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMPReserved for IBM internal use.
LAST_UPDATED_IDINTEGER NOT NULL DEFAULT 0Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MEMBER_ID+SUB_ID+SEGMENTATION_IDPrimary Key
I0000272SEGMENTATION_ID+SEGMENT_INDEX+SCORENon-Unique Index