PLWIDGETDEF

Contains information about all widgets registered on the system.

Column Descriptions:

NameTypeDescription
PLWIDGETDEF_IDBIGINT NOT NULLPrimary key for the widget definition.
STOREENT_IDINTEGER NOT NULLThe 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.
IDENTIFIERVARCHAR (256) NOT NULLA unique identifier for a widget in a store.
UI_OBJECT_NAMEVARCHAR (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.
VENDORVARCHAR (128) NOT NULLThe vendor from whom the widget was sourced.
WIDGETTYPESMALLINT NOT NULL DEFAULT 1A 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.
JSPPATHVARCHAR (512) NOT NULLThe 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.
DEFINITIONXMLCLOB (1000000) NOT NULLThe 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.
STATESMALLINT NOT NULL DEFAULT 0The 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
CREATEDATETIMESTAMP NOT NULLThe time when the widget definition was created.
LASTUPDATETIMESTAMP NOT NULLThe time when the widget definition was last updated.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
P_0018PLWIDGETDEF_IDPrimary Key
I0001488IDENTIFIER+STOREENT_IDUnique Index
I0001511STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3746STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3747PLWIDGETDEF_IDPLWIDGETDEFDESCPLWIDGETDEF_IDCascade
F_3749PLWIDGETDEF_IDPLSTOREWIDGETPLWIDGETDEF_IDCascade
F_3751PLWIDGETDEF_IDPLWIDGETPLWIDGETDEF_IDCascade