| PAGELAYOUT_ID | BIGINT NOT NULL | Primary key for this layout. |
| NAME | VARCHAR (256) NOT NULL | The name of the page layout. |
| VIEWNAME | VARCHAR (256) | View name for page layout that overrides value in
VIEWNAME column in STOREPLTYPES |
| MEMBER_ID | BIGINT NOT NULL | The owner of the page layout. |
| STOREENT_ID | INTEGER NOT NULL | Store in which the page layout is used. |
| PAGELAYOUTTYPE_ID | VARCHAR (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. |
| DESCRIPTION | VARCHAR (1024) | The description of the page layout. |
| THUMBNAIL | VARCHAR (256) | The thumbnail image path of the page layout. |
| FULLIMAGE | VARCHAR (256) | The full image path of the page layout. |
| MASTERCSS | VARCHAR (256) | Master CSS defined for the page layout. |
| DEVICETYPE | VARCHAR (64) NOT NULL | The 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. |
| STATE | SMALLINT NOT NULL DEFAULT 1 | The state of the page layout.
0=inactive
1=active
2=mark for delete |
| ISTEMPLATE | SMALLINT NOT NULL DEFAULT 0 | Flag indicating whether its a layout template.
0=layout(editable)
1=layout template(not editable) |
| CREATEDATE | TIMESTAMP | Indicates the time at which the page layout was
created. |
| LASTUPDATE | TIMESTAMP | Indicates the last time at which the layout was
updated. |
| FIELD1 | INTEGER | Customizable field. |
| FIELD2 | VARCHAR (256) | Customizable field. |
| FIELD3 | VARCHAR (256) | Customizable field. |
| UP_NAME | VARCHAR (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. |
| ISDEFAULT | SMALLINT NOT NULL DEFAULT 0 | This 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 |
| STARTDATE | TIMESTAMP | The start time for the page layout. If the start
time is null, then the page layout can start immediately. |
| ENDDATE | TIMESTAMP | The end time for the page layout. If the end time
is null, then the page layout will run indefinitely. |
| PRIORITY | SMALLINT NOT NULL DEFAULT 0 | The priority of the page layout. The default
value is 0. |
| MANAGINGTOOL | SMALLINT NOT NULL DEFAULT 0 | This 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. |
| 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. |