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:

NameTypeDescription
PLLOCATION_IDBIGINT NOT NULLThe primary key of this page location.
PAGELAYOUT_IDBIGINT NOT NULLThe primary key of the page layout that has this location. Foreign key to the PAGELAYOUT table.
DMACTIVITY_IDINTEGER NOT NULLThe primary key of the web activity that defines a rule and mapping between a page and a layout. Foreign key to the DMACTIVITY table.
GROUPNUMBERSMALLINT NOT NULL DEFAULT 0Reserved for IBM internal use. Set to 0.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
P_0026PLLOCATION_IDPrimary Key
I0001496PAGELAYOUT_ID+DMACTIVITY_IDUnique Index
I0001497DMACTIVITY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3760PAGELAYOUT_IDPAGELAYOUTPAGELAYOUT_IDCascade
F_3761DMACTIVITY_IDDMACTIVITYDMACTIVITY_IDCascade