SEOPAGEDEFSUBPARAM

This table holds the predefined substitution parameters which can be used while creating the title and meta description. At run-time the substitution parameter will be replaced with the values based on the request properties

Column Descriptions:

NameTypeDescription
SUBPARAMNAMEVARCHAR (254) NOT NULLThe name of the substitution parameter used within the page definition descriptions such as the title, meta description and image alternate description.
STOREENT_IDINTEGER NOT NULLThe reference number of the store entity that the substitution parameter belongs to.
ADMINDESCVARCHAR (254)The description of the substitution parameter.
CLASSNAMEVARCHAR (254) NOT NULLThe name of the class to retrieve the substitution parameter value from.
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>SUBPARAMNAME+STOREENT_IDPrimary Key
I0001415STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3703STOREENT_IDSTOREENTSTOREENT_IDCascade