This table contains information about various layouts present in the system

Column Descriptions:

PAGELAYOUT_IDBIGINT NOT NULLPrimary key for this layout.
NAMEVARCHAR (256) NOT NULLThe name of the page layout.
VIEWNAMEVARCHAR (256)View name for page layout that overrides value in VIEWNAME column in STOREPLTYPES
MEMBER_IDBIGINT NOT NULLThe owner of the page layout.
STOREENT_IDINTEGER NOT NULLStore in which the page layout is used.
PAGELAYOUTTYPE_IDVARCHAR (32)For default layouts, the page group that the default layout belongs to, for example: - Category - Content - Search - Product - Kit - Bundle - DynamicKit For templates and non-default layouts, this value must be null. Note: The term "page group" is used instead of "page layout type" in the documentation, data load input files and web services. Foreign key to the PAGELAYOUTTYPE table.
DESCRIPTIONVARCHAR (1024)The description of the page layout.
THUMBNAILVARCHAR (256)The thumbnail image path of the page layout.
FULLIMAGEVARCHAR (256)The full image path of the page layout.
MASTERCSSVARCHAR (256)Master CSS defined for the page layout.
DEVICETYPEVARCHAR (64) NOT NULLThe class of the device that this layout is designed to render a store page for, for example: - Mobile - Web - Any (responsive web page) Note: The term "device class" is used instead of "device type" in the documentation, data load input files, and for layout resolution.
STATESMALLINT NOT NULL DEFAULT 1The state of the page layout. 0=inactive 1=active 2=mark for delete
ISTEMPLATESMALLINT NOT NULL DEFAULT 0Flag indicating whether its a layout template. 0=layout(editable) 1=layout template(not editable)
CREATEDATETIMESTAMPIndicates the time at which the page layout was created.
LASTUPDATETIMESTAMPIndicates the last time at which the layout was updated.
FIELD1INTEGERCustomizable field.
FIELD2VARCHAR (256)Customizable field.
FIELD3VARCHAR (256)Customizable field.
UP_NAMEVARCHAR (256)The equivalent value of the NAME column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
ISDEFAULTSMALLINT NOT NULL DEFAULT 0This flag indicates whether the page layout is a default page layout. Only 1 default page layout should exist for each page layout type. 0=Not Default 1=Default
STARTDATETIMESTAMPThe start time for the page layout. If the start time is null, then the page layout can start immediately.
ENDDATETIMESTAMPThe end time for the page layout. If the end time is null, then the page layout will run indefinitely.
PRIORITYSMALLINT NOT NULL DEFAULT 0The priority of the page layout. The default value is 0.
MANAGINGTOOLSMALLINT NOT NULL DEFAULT 0This Column indicates which tool manages the layout. NULL or 0 indicates that the layout is managed by the CMC. 1 indicates that the layout is managed by the Commerce Workbench tool.
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.


NameColumn NamesType
P_0005PAGELAYOUT_IDPrimary Key
IPF00030UP_NAMENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType