PAGELAYOUT

This table contains information about various layouts present in the system

Column Descriptions:

NameTypeDescription
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.

Indexes:

NameColumn NamesType
P_0005PAGELAYOUT_IDPrimary Key
I0001443NAME+MEMBER_ID+MANAGINGTOOLUnique Index
I0001444NAME+STOREENT_ID+MANAGINGTOOLUnique Index
I0001445STOREENT_ID+PAGELAYOUTTYPE_IDNon-Unique Index
IPF00030UP_NAMENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3719PAGELAYOUTTYPE_IDPAGELAYOUTTYPEPAGELAYOUTTYPE_IDCascade
F_3720STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3752PAGELAYOUT_IDPLWIDGETPAGELAYOUT_IDCascade
F_3753PAGELAYOUT_IDPLWIDGETSLOTPAGELAYOUT_IDCascade
F_3760PAGELAYOUT_IDPLLOCATIONPAGELAYOUT_IDCascade
F_3766PAGELAYOUT_IDPLTEMPLATERELPAGELAYOUT_IDCascade
F_3767PAGELAYOUT_IDPLTEMPLATERELTEMPLATE_IDCascade
F_3771PAGELAYOUT_IDPLLOCSTATICPAGELAYOUT_IDCascade
F_3772PAGELAYOUT_IDPLPROPERTYPAGELAYOUT_IDCascade