PX_ELEMENT

This table contains promotion element information.

Column Descriptions:

NameTypeDescription
PX_ELEMENT_IDBIGINT NOT NULLPrimary key of the table.
PX_PROMOTION_IDINTEGER NOT NULLPrimary key of the table.
NAMEVARCHAR (254) NOT NULLName to identify the element.
TYPEVARCHAR (254) NOT NULLType of the element.
SUBTYPEVARCHAR (254)Subtype of the element.
PARENTVARCHAR (254)Parent name of the element.
SEQUENCEDOUBLE NOT NULL DEFAULT 0Sequence number.
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_ELEMENT_IDPrimary Key
I0001201PX_PROMOTION_ID+NAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3546PX_PROMOTION_IDPX_PROMOTIONPX_PROMOTION_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3547PX_ELEMENT_IDPX_ELEMENTNVPPX_ELEMENT_IDCascade