SEOURLKEYWORD

This table holds the store and language specific SEO URL keyword information

Column Descriptions:

NameTypeDescription
SEOURLKEYWORD_IDBIGINT NOT NULLGenerated unique key to denote the SEO URL keyword ID.
SEOURL_IDBIGINT NOT NULLThe internal reference number that indicates which SEO URL this language specific information relates to.
LANGUAGE_IDINTEGER NOT NULLThe identifier of the language.
STOREENT_IDINTEGER NOT NULLThe reference number of the store entity the URL keyword belongs to.
URLKEYWORDVARCHAR (254) NOT NULLThe SEO URL keyword.
MOBILEURLKEYWORDVARCHAR (254)Reserved for HCL internal use.
STATUSINTEGER NOT NULL DEFAULT 1The status of the URL keyword.
  • 0 - INACTIVE
  • 1 - ACTIVE
  • 2 - EXPIRED
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>SEOURLKEYWORD_IDPrimary Key
I0001417URLKEYWORD+STOREENT_IDUnique Index
I0001420SEOURL_IDNon-Unique Index
I0001421STOREENT_IDNon-Unique Index
I0001430LANGUAGE_IDNon-Unique Index
I0001433MOBILEURLKEYWORD+STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3704SEOURL_IDSEOURLSEOURL_IDCascade
F_3705STOREENT_IDSTOREENTSTOREENT_IDCascade
F_3706LANGUAGE_IDLANGUAGELANGUAGE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3701SEOURLKEYWORD_IDSEOREDIRECTSEOURLKWD_ID_NEWCascade
F_3702SEOURLKEYWORD_IDSEOREDIRECTSEOURLKWD_ID_ORIGCascade