PLSTOREWIDGET
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 - ActiveDEFINITIONXML 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
Related reference
Commerce Composer data model