PX_ELEMENTNVP

This table contains promotion element values.

Column Descriptions:

NameTypeDescription
PX_ELEMENTNVP_IDBIGINT NOT NULLPrimary key of the table.
PX_ELEMENT_IDBIGINT NOT NULLForeign key to the PX_ELEMENT table.
NAMEVARCHAR (254) NOT NULLName of the name-value pair (NVP).
VALUEVARCHAR (254) NOT NULLValue of the name-value pair (NVP).
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_ELEMENTNVP_IDPrimary Key
I0001197PX_ELEMENT_ID+NAME+VALUEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3547PX_ELEMENT_IDPX_ELEMENTPX_ELEMENT_IDCascade