SEOPAGEDEF

This table holds the SEO page definition for a particular pageName at a site/store level

Column Descriptions:

NameTypeDescription
SEOPAGEDEF_IDBIGINT NOT NULLGenerated unique key for the SEO page definition.
PAGENAMEVARCHAR (64) NOT NULLThe name of the page for which the page definition is stored.
STOREENT_IDINTEGER NOT NULLThe reference number of the store entity to which the page belongs.
LASTUPDATETIMESTAMP NOT NULLThe last time the page definition was updated.
CREATEDTIMETIMESTAMP NOT NULLThe time the page definition is created.
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
<SYSTEM-GENERATED>SEOPAGEDEF_IDPrimary Key
I0001409PAGENAME+STOREENT_IDUnique Index
I0001410STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3697STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3698SEOPAGEDEF_IDSEOPAGEDEFDESCSEOPAGEDEF_IDCascade
F_3700SEOPAGEDEF_IDSEOPAGEDEFOVRSEOPAGEDEF_IDCascade