CPOFFER

This table is deprecated and is provided for backward compatibility only. This table is replaced by px_promotion related tables.

Column Descriptions:

NameTypeDescription
CPPMN_IDINTEGER NOT NULLReserved for IBM internal use.
USERS_IDBIGINT NOT NULLReserved for IBM internal use.
STATECHAR (4) NOT NULLReserved for IBM internal use.
FIRSTTIMESEENTIMESTAMPReserved for IBM internal use.
FIELD1VARCHAR (64)Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CPPMN_ID+USERS_IDPrimary Key
I0000545USERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_263USERS_IDUSERSUSERS_IDCascade
F_264CPPMN_IDCPPMNCPPMN_IDCascade