WebSphere Commerce database table: CPPMNDESC

This table contains the language specific description of the promotion.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031217940 CPPMN_ID+LANGUAGE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_270 CPPMN_ID CPPMN CPPMN_ID Cascade
F_269 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback