PX_PROMPROM

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
PX_PROMO_ID_FROMINTEGER NOT NULLIn a promotion to promotion relationship, this is the "from" end of the relationship.
PX_PROMO_ID_TOINTEGER NOT NULLIn a promotion to promotion relationship, this is the "to" end of the relationship.
RELATIONSMALLINT NOT NULLThe type of relationship between the two promotions. Possible values include: 1: The promotions are mutually exclusive 2: The "from" promotion excludes the "to" promotion. 3: The promotions can be combined. The default value is 1.
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
I0000421PX_PROMO_ID_FROMNon-Unique Index
I0000422PX_PROMO_ID_TONon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1078PX_PROMO_ID_FROMPX_PROMOTIONPX_PROMOTION_IDCascade
F_1079PX_PROMO_ID_TOPX_PROMOTIONPX_PROMOTION_IDCascade