PX_DESCRIPTION

This table contains promotion description information.

Column Descriptions:

NameTypeDescription
PX_PROMOTION_IDINTEGER NOT NULLForeign key to the PX_PROMOTION table.
LANGUAGE_IDINTEGER NOT NULLForeign key to the LANGUAGE table. The language to which this information applies.
ADMINDESCVARCHAR (254)Reserved for IBM internal use.
SHORTDESCVARCHAR (254)Short description.
LONGDESCVARCHAR (4000)Long description.
FIELD1VARCHAR (254)Custom description 1.
FIELD2VARCHAR (254)Custom description 2.
FIELD3VARCHAR (254)Custom description 3.
FIELD4VARCHAR (254)Custom description 4.
FIELD5VARCHAR (254)Custom description 5.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PX_PROMOTION_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3548PX_PROMOTION_IDPX_PROMOTIONPX_PROMOTION_IDCascade
F_3549LANGUAGE_IDLANGUAGELANGUAGE_IDCascade