CPOFFER

Deprecated. Provided for backward compatibility only. This table is replaced by PX_PROMOTION related tables.

Column Descriptions:

Name	Type	Description
CPPMN_ID	INTEGER NOT NULL	Reserved for IBM internal use.
USERS_ID	BIGINT NOT NULL	Reserved for IBM internal use.
STATE	CHAR (4) NOT NULL	Reserved for IBM internal use.
FIRSTTIMESEEN	TIMESTAMP	Reserved for IBM internal use.
FIELD1	VARCHAR (64)	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CPPMN_ID+USERS_ID	Primary Key
I0000545	USERS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_263	USERS_ID	USERS	USERS_ID	Cascade
F_264	CPPMN_ID	CPPMN	CPPMN_ID	Cascade