WebSphere Commerce database table: CPPMNDESC

This table contains the language specific description of the promotion. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.

Column Descriptions
Column Name Column Type Description
CPPMN_ID INTEGER NOT NULL Foreign key to the CPPMN table. This is a primary key.
LANGUAGE_ID INTEGER NOT NULL Foreign key to LANGUAGE table. For a list of language components, see the LANGUAGE table. This is a primary key.
THUMBNAILPATH VARCHAR(254) Path of the thumbnail to be shown for this promotion for this language.
FULLIMAGEPATH VARCHAR(254) Path of the full image to be shown for this promotion for this language.
SHORTDESC VARCHAR(64) Short description of the promotion for this language.
LONGDESC VARCHAR(254) Long description of the promotion for this language.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235147650 CPPMN_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_270 CPPMN_ID CPPMN CPPMN_ID Cascade
F_269 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference