Reference > Database > WebSphere Commerce database tables > C
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 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 SQL100520030321180 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
_vcc_freeselect_bottom_