Database Table: CPPMNDESC

This table contains the language specific description of the promotion.

Column Name Column Type Column Description
CPPMN_ID INTEGER
NOT NULL
Primary Key. Foreign key to CPPMN table.
FULLIMAGEPATH VARCHAR (254)
NULL
Path of the full image to be shown for this promotion for this language.
LANGUAGE_ID INTEGER
NOT NULL
Primary key. Foreign key to LANGUAGE table. For a list of language components, see the LANGUAGE table.
LONGDESC VARCHAR (254)
NULL
Long description of the promotion.
SHORTDESC VARCHAR (64)
NULL
Short description of the promotion.
THUMBNAILPATH VARCHAR (254)
NULL
Path of the thumbnail to be shown for this promotion for this language.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034916550 CPPMN_ID, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_269 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_270 CPPMN_ID CPPMN CPPMN_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable