PX_CDPROMO

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

Column Descriptions:

NameTypeDescription
PX_CDPROMO_IDBIGINT NOT NULLPrimary key.
PX_CDPOOL_IDBIGINT NOT NULLForeign key to PX_CDPOOL.
PX_PROMOTION_IDINTEGER NOT NULLForeign key to PX_PROMOTION.
STATUSSMALLINT NOT NULL DEFAULT 00: Inactive 1: Active
LASTUPDATETIMESTAMPCurrently not in use.
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_CDPROMO_IDPrimary Key
I0001315PX_CDPOOL_ID+PX_PROMOTION_IDUnique Index
I0001316PX_PROMOTION_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3606PX_PROMOTION_IDPX_PROMOTIONPX_PROMOTION_IDCascade
F_3607PX_CDPOOL_IDPX_CDPOOLPX_CDPOOL_IDCascade