Contains information about all widgets registered
on the system.
Column Descriptions:
| Name | Type | Description |
| PLWIDGETDEF_ID | BIGINT NOT NULL | Primary key for the widget definition. |
| STOREENT_ID | INTEGER NOT NULL | The primary key for the store the widget exists
in. If STOREENT_ID is 0, then the widget is considered to be at the
site level and can be associated to several stores using the
PLSTOREWIDGET table. If STOREENT_ID is store specific, then the
widget is assumed to exist within a specific store folder and
should not be shared by other stores. |
| IDENTIFIER | VARCHAR (256) NOT NULL | A unique identifier for a widget in a store. |
| UI_OBJECT_NAME | VARCHAR (128) | The name referring to the child object definition
used in the business tools. The business tools use this definition
to display widget properties on the screen. |
| VENDOR | VARCHAR (128) NOT NULL | The vendor from whom the widget was sourced. |
| WIDGETTYPE | SMALLINT NOT NULL DEFAULT 1 | A value representing the type of this widget.
1 - Widget
2 - Container
Widgets are a type of container. Containers can contain other
containers or widgets. All Widgets are placed inside of a
container. A PLWIDGETDEF entry is used to specify the definition
for containers as well as widgets. |
| JSPPATH | VARCHAR (512) NOT NULL | The path name of the JSP representing the widget.
If STOREENT_ID is 0, the path name is relative to the Stores WAR
the widget is in and should begin with a forward slash (/). If
STOREENT_ID is not 0, then the reference is relative to the store's
directory and does not begin with a forward slash. |
| DEFINITIONXML | CLOB (1000000) NOT NULL | The XML definition of the widget. This field
indicates properties supported by the widget, default values of
properties and more. See documentation for the complete
specification of this field. |
| STATE | SMALLINT NOT NULL DEFAULT 0 | The flag to indicate if the widget is removed
from the system. Deleted widgets may be removed from the system
along with associations setup in the PLSTOREWIDGET table. If this
widget is still being used in a store, then this definition should
not be deleted.
0 - Deprecated
1 - Current |
| CREATEDATE | TIMESTAMP NOT NULL | The time when the widget definition was
created. |
| LASTUPDATE | TIMESTAMP NOT NULL | The time when the widget definition was last
updated. |
| 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_0018 | PLWIDGETDEF_ID | Primary Key |
| I0001488 | IDENTIFIER+STOREENT_ID | Unique Index |
| I0001511 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3746 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3747 | PLWIDGETDEF_ID | PLWIDGETDEFDESC | PLWIDGETDEF_ID | Cascade |
| F_3749 | PLWIDGETDEF_ID | PLSTOREWIDGET | PLWIDGETDEF_ID | Cascade |
| F_3751 | PLWIDGETDEF_ID | PLWIDGET | PLWIDGETDEF_ID | Cascade |