PLWIDGET

This table contains the association of widgets to page layouts.

Column Descriptions:

Name	Type	Description
PLWIDGET_ID	BIGINT NOT NULL	The primary key of this widget.
PAGELAYOUT_ID	BIGINT NOT NULL	Defines the page layout this widget is used on. Foreign key to the PAGELAYOUT table.
PLWIDGETDEF_ID	BIGINT NOT NULL	Defines the widget used in this association. Foreign key to the PLWIDGETDEF table.
ADMINNAME	VARCHAR (256) NOT NULL	An administrative name for a widget or a container in a layout.
SLOTID	VARCHAR (64)	The internal name of the slot in the layout where the widget resides. Used at runtime to determine the slot in which the widget is placed.
FIELD1	INTEGER	Customizable field.
FIELD2	VARCHAR (256)	Customizable field.
FIELD3	VARCHAR (256)	Customizable field.
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_0021	PLWIDGET_ID	Primary Key
I0001489	PAGELAYOUT_ID+ADMINNAME	Unique Index
I0001514	PLWIDGETDEF_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3751	PLWIDGETDEF_ID	PLWIDGETDEF	PLWIDGETDEF_ID	Cascade
F_3752	PAGELAYOUT_ID	PAGELAYOUT	PAGELAYOUT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3754	PLWIDGET_ID	PLWIDGETSLOT	PLWIDGET_ID	Cascade
F_3755	PLWIDGET_ID	PLWIDGETNVP	PLWIDGET_ID	Cascade
F_3756	PLWIDGET_ID	PLWIDGETREL	PLWIDGET_ID_PARENT	Cascade
F_3757	PLWIDGET_ID	PLWIDGETREL	PLWIDGET_ID_CHILD	Cascade

Related reference
Commerce Composer data model