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:
Name | Type | Description |
PLWIDGET_ID_PARENT | BIGINT | The 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_CHILD | BIGINT NOT NULL | The primary key of the widget or container.
Typically widgets are all placed inside of containers. Foreign key
to the PLWIDGET table. |
SEQUENCE | DOUBLE DEFAULT 0.0 | The order of the child widget or child container
inside of a parent container. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
P_0024 | PLWIDGET_ID_CHILD | Primary Key |
I0001516 | PLWIDGET_ID_PARENT | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_3756 | PLWIDGET_ID_PARENT | PLWIDGET | PLWIDGET_ID | Cascade |
F_3757 | PLWIDGET_ID_CHILD | PLWIDGET | PLWIDGET_ID | Cascade |