PLLOCATION

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