PLWIDGETSLOT

Used by the business tool to display and name slots on a page layout. This table defines the configurable slots on a page layout.

Column Descriptions:

NameTypeDescription
PLWIDGETSLOT_IDBIGINT NOT NULLThe primary key of this table.
PAGELAYOUT_IDBIGINT NOT NULLThe page layout to which the slot belongs. Foreign key to the PAGELAYOUT table.
PLWIDGET_IDBIGINT NOT NULLTypically a primary key for a container on a page layout. Foreign key to the PLWIDGET table.
ADMINNAMEVARCHAR (256) NOT NULLThe viewable name in the business tool for a slot. Typically single character names are preferred.
SLOTIDVARCHAR (64) NOT NULLThe internal slot name used and persisted to the PLWIDGET table when a business user places a widget in a slot identified by the ADMINNAME.
SLOTTYPESMALLINT NOT NULL DEFAULT 1Reserved for IBM internal use.
PROPERTIESVARCHAR (1024) NOT NULLThe properties the business tool uses to draw a page template on the screen. Each PLWIDGETSLOT entry for a PAGELAYOUT_ID, defines a slot on the screen that can be identified by a rectangular area. Example: xLocation:0;yLocation:0;width:166;height:24;state:disabled
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_0022PLWIDGETSLOT_IDPrimary Key
I0001490PAGELAYOUT_ID+ADMINNAMEUnique Index
I0001515PLWIDGET_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3753PAGELAYOUT_IDPAGELAYOUTPAGELAYOUT_IDCascade
F_3754PLWIDGET_IDPLWIDGETPLWIDGET_IDCascade