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:

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 HCL 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