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:
| Name | Type | Description |
| PLWIDGETSLOT_ID | BIGINT NOT NULL | The primary key of this table. |
| PAGELAYOUT_ID | BIGINT NOT NULL | The page layout to which the slot belongs.
Foreign key to the PAGELAYOUT table. |
| PLWIDGET_ID | BIGINT NOT NULL | Typically a primary key for a container on a page
layout. Foreign key to the PLWIDGET table. |
| ADMINNAME | VARCHAR (256) NOT NULL | The viewable name in the business tool for a
slot. Typically single character names are preferred. |
| SLOTID | VARCHAR (64) NOT NULL | The internal slot name used and persisted to the
PLWIDGET table when a business user places a widget in a slot
identified by the ADMINNAME. |
| SLOTTYPE | SMALLINT NOT NULL DEFAULT 1 | Reserved for IBM internal use. |
| PROPERTIES | VARCHAR (1024) NOT NULL | The 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 |
| 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_0022 | PLWIDGETSLOT_ID | Primary Key |
| I0001490 | PAGELAYOUT_ID+ADMINNAME | Unique Index |
| I0001515 | PLWIDGET_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3753 | PAGELAYOUT_ID | PAGELAYOUT | PAGELAYOUT_ID | Cascade |
| F_3754 | PLWIDGET_ID | PLWIDGET | PLWIDGET_ID | Cascade |