CPPMNDESC

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.
LANGUAGE_ID INTEGER NOT NULL Reserved for IBM internal use.
THUMBNAILPATH VARCHAR (254) Reserved for IBM internal use.
FULLIMAGEPATH VARCHAR (254) Reserved for IBM internal use.
SHORTDESC VARCHAR (64) Reserved for IBM internal use.
LONGDESC VARCHAR (254) 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+LANGUAGE_ID Primary Key


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_269 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_270 CPPMN_ID CPPMN CPPMN_ID Cascade