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 | Reserved for IBM 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 |