This table contains information about the static
assignment of a layout to a user. Each PAGELAYOUT entry can have at
most one entry in this table.
Column Descriptions:
Name | Type | Description |
PLLOCSTATIC_ID | BIGINT NOT NULL | Primary key to the table. |
PAGELAYOUT_ID | BIGINT NOT NULL | The unique ID of the corresponding page
layout. |
OWNER_ID | BIGINT NOT NULL | The owner or user of the layout. |
LOCATIONNAME | VARCHAR (256) NOT NULL | The name of the static location. |
ISDEFAULT | SMALLINT NOT NULL DEFAULT 0 | This flag indicates whether the location is
default for the user. 0 - Not default 1- Default |
SEQUENCE | DOUBLE NOT NULL DEFAULT 0.0 | The sequence of the static assignment for an
ownerID. |
UP_LOCATIONNAME | VARCHAR (256) | The equivalent value of the LOCATIONNAME column
in upper case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based search queries
issued on the table. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | Reserved for HCL internal use. |
Indexes:
Name | Column Names | Type |
P_0033 | PLLOCSTATIC_ID | Primary Key |
I0001523 | PAGELAYOUT_ID | Unique Index |
IPF00036 | UP_LOCATIONNAME | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_3771 | PAGELAYOUT_ID | PAGELAYOUT | PAGELAYOUT_ID | Cascade |