Each row specifies the relationship between a store
and available widgets. Each available widget is allowed to be added
to page layouts within the specified store.
Column Descriptions:
| Name | Type | Description |
| PLSTOREWIDGET_ID | BIGINT NOT NULL | Primary key for the table. |
| STOREENT_ID | INTEGER NOT NULL | The primary key of the store in which the store
to widget association exists. Foreign key to the STOREENT
table. |
| PLWIDGETDEF_ID | BIGINT NOT NULL | Defines and specifies details of a widget.
Foreign key to the PLWIDGETDEF table. |
| STATE | SMALLINT NOT NULL DEFAULT 1 | State of the subscription. If a widget should no
longer be used in a store, set this value to 0. Stores are allowed
to use inactive widgets however these widgets can no longer be
assigned to page layouts through business tools.
0 - Inactive
1 - Active |
| DEFINITIONXML | CLOB (1000000) | When a store subscribes to a widget by making an
entry in the PLSTOREWIDGET table, it can optionally provide it's
own definition XML to override the definition set during widget
registration. See the PLWIDGETDEF table to view the widget
definition. |
| 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_0020 | PLSTOREWIDGET_ID | Primary Key |
| I0001512 | PLWIDGETDEF_ID+STOREENT_ID | Unique Index |
| I0001513 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3749 | PLWIDGETDEF_ID | PLWIDGETDEF | PLWIDGETDEF_ID | Cascade |
| F_3750 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |