Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_DESCRIPTION
This table contains promotion description information.
Column Name Column Type Description PX_PROMOTION_ID INTEGER NOT NULL Foreign key to the PX_PROMOTION table. LANGUAGE_ID INTEGER NOT NULL Foreign key to the LANGUAGE table. The language to which this information applies. ADMINDESC VARCHAR(254) Foreign key to the LANGUAGE table. The language to which this information applies.. SHORTDESC VARCHAR(254) Short description. LONGDESC VARCHAR(4000) Long description. FIELD1 VARCHAR(254) Custom description 1. FIELD2 VARCHAR(254) Custom description 2. FIELD3 VARCHAR(254) Custom description 3. FIELD4 VARCHAR(254) Custom description 4. FIELD5 VARCHAR(254) Custom description 5. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030416530 PX_PROMOTION_ID+LANGUAGE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3549 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade F_3548 PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade _vcc_freeselect_bottom_