PLPAGE

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:

NameTypeDescription
PLPAGE_IDINTEGER NOT NULLThe primary key of this page.
ADMINNAMEVARCHAR (256) NOT NULLA unique administrative name of the store page.
MEMBER_IDBIGINT NOT NULLThe owner of the page. Foreign key to the MEMBER table.
STOREENT_IDINTEGER NOT NULLThe primary key of the store in which the page was created. Foreign key to the STOREENT table.
PAGELAYOUTTYPE_IDVARCHAR (32) NOT NULLThe 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.
DELETABLESMALLINT NOT NULL DEFAULT 1This 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
ADMINNAMEEDITABLESMALLINT NOT NULL DEFAULT 1This 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)
URLCONFIGURABLESMALLINT NOT NULL DEFAULT 1This 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)
FIELD1INTEGERCustomizable field.
FIELD2VARCHAR (256)Customizable field.
FIELD3VARCHAR (256)Customizable field.
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_0025PLPAGE_IDPrimary Key
I0001492ADMINNAME+MEMBER_IDUnique Index
I0001493ADMINNAME+STOREENT_IDUnique Index
I0001494STOREENT_ID+PAGELAYOUTTYPE_IDNon-Unique Index
I0001495PAGELAYOUTTYPE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3758PAGELAYOUTTYPE_IDPAGELAYOUTTYPEPAGELAYOUTTYPE_IDCascade
F_3759STOREENT_IDSTOREENTSTOREENT_IDCascade