PLWIDGETNVP

This table contains information about the properties configured for a widget or container. Widgets and containers have properties when configured on a page layout.

Column Descriptions:

NameTypeDescription
PLWIDGETNVP_IDBIGINT NOT NULLThe primary key of this table.
PLWIDGET_IDBIGINT NOT NULLThe widget these properties belong to. Foreign key to the PLWIDGET table.
NAMEVARCHAR (256) NOT NULLName of the property.
VALUEVARCHAR (256) NOT NULLValue of the property.
PROPERTIESVARCHAR (1024)Reserved for internal use.
SEQUENCEDOUBLE NOT NULL DEFAULT 0.0Sequence of the properties.
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
P_0023PLWIDGETNVP_IDPrimary Key
I0001491NAME+VALUE+PLWIDGET_IDUnique Index
I0001519PLWIDGET_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3755PLWIDGET_IDPLWIDGETPLWIDGET_IDCascade