Specifies an indirect mapping between store pages
and the location where they are used in the store. For every
assignment of a page layout to a page, a web activity is created
and referenced in this table. A 1:1 mapping exists between a page
layout location and a web activity. The web activity determines
which layout is used on a given page. This table provided the
association between the layout and locations which you can see
displayed through business tools.
Column Descriptions:
Name | Type | Description |
PLLOCATION_ID | BIGINT NOT NULL | The primary key of this page location. |
PAGELAYOUT_ID | BIGINT NOT NULL | The primary key of the page layout that has this
location. Foreign key to the PAGELAYOUT table. |
DMACTIVITY_ID | INTEGER NOT NULL | The primary key of the web activity that defines
a rule and mapping between a page and a layout. Foreign key to the
DMACTIVITY table. |
GROUPNUMBER | SMALLINT NOT NULL DEFAULT 0 | Reserved for IBM internal use. Set to 0. |
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_0026 | PLLOCATION_ID | Primary Key |
I0001496 | PAGELAYOUT_ID+DMACTIVITY_ID | Unique Index |
I0001497 | DMACTIVITY_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_3760 | PAGELAYOUT_ID | PAGELAYOUT | PAGELAYOUT_ID | Cascade |
F_3761 | DMACTIVITY_ID | DMACTIVITY | DMACTIVITY_ID | Cascade |