PX_DESCRIPTION

This table contains promotion description information.

Column Descriptions:

Name	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)	Reserved for IBM internal use.
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	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PX_PROMOTION_ID+LANGUAGE_ID	Primary Key

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3548	PX_PROMOTION_ID	PX_PROMOTION	PX_PROMOTION_ID	Cascade
F_3549	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade