PLWIDGETREL

This table contains information about the relationship between widgets on a page layout. Defines a hierarchy of containers and widgets on a page.

Column Descriptions:

NameTypeDescription
PLWIDGET_ID_PARENTBIGINTThe primary key of the parent widget or container. The root container is expected to be NULL. All other containers and widgets on the page have a parent. Foreign key to the PLWIDGET table.
PLWIDGET_ID_CHILDBIGINT NOT NULLThe primary key of the widget or container. Typically widgets are all placed inside of containers. Foreign key to the PLWIDGET table.
SEQUENCEDOUBLE DEFAULT 0.0The order of the child widget or child container inside of a parent container.
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_0024PLWIDGET_ID_CHILDPrimary Key
I0001516PLWIDGET_ID_PARENTNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3756PLWIDGET_ID_PARENTPLWIDGETPLWIDGET_IDCascade
F_3757PLWIDGET_ID_CHILDPLWIDGETPLWIDGET_IDCascade