Each entry specifies a page in the web site. A page
is defined by an administrative name, type of page, URL and SEO
metadata.
Column Descriptions:
| Name | Type | Description |
| PLPAGE_ID | INTEGER NOT NULL | The primary key of this page. |
| ADMINNAME | VARCHAR (256) NOT NULL | A unique administrative name of the store
page. |
| MEMBER_ID | BIGINT NOT NULL | The owner of the page. Foreign key to the MEMBER
table. |
| STOREENT_ID | INTEGER NOT NULL | The primary key of the store in which the page
was created. Foreign key to the STOREENT table. |
| PAGELAYOUTTYPE_ID | VARCHAR (32) NOT NULL | The categorization of this particular page.
Currently the only value supported is 'Content'.
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.
|
| DELETABLE | SMALLINT NOT NULL DEFAULT 1 | This flag indicates whether the page can be
deleted from business tooling. This flag protects critical pages
from being deleted such as your Home Page and Contact pages.
0=Not Deletable
1=Deletable |
| ADMINNAMEEDITABLE | SMALLINT NOT NULL DEFAULT 1 | This flag indicates if the ADMINNAME of the page
is editable or not through business tools. In some cases the
ADMINNAME is used in JSPs to lookup the SEO URL of the page. If you
write custom logic requiring this lookup, set ADMINNAMEEDITABLE to
0.
0 = False (Cannot be edited)
1 = True (Can be edited) |
| URLCONFIGURABLE | SMALLINT NOT NULL DEFAULT 1 | This flag indicates if the URL keyword of the
page is configurable through business tools. Set to 0 if you do not
allows business users to change the URL of the page. Store home
pages should be set to 0.
0 = False (Not configurable)
1 = True (Configurable) |
| FIELD1 | INTEGER | Customizable field. |
| FIELD2 | VARCHAR (256) | Customizable field. |
| FIELD3 | VARCHAR (256) | Customizable field. |
| 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_0025 | PLPAGE_ID | Primary Key |
| I0001492 | ADMINNAME+MEMBER_ID | Unique Index |
| I0001493 | ADMINNAME+STOREENT_ID | Unique Index |
| I0001494 | STOREENT_ID+PAGELAYOUTTYPE_ID | Non-Unique Index |
| I0001495 | PAGELAYOUTTYPE_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3758 | PAGELAYOUTTYPE_ID | PAGELAYOUTTYPE | PAGELAYOUTTYPE_ID | Cascade |
| F_3759 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |