SEOURL

This table holds the token and sitemap information for a particular URL

Column Descriptions:

NameTypeDescription
SEOURL_IDBIGINT NOT NULLGenerated unique key to denote the SEO URL ID.
TOKENNAMEVARCHAR (254) NOT NULLThe name of the token associated with the URL keyword.
TOKENVALUEVARCHAR (254) NOT NULLThe token value for the SEO URL keyword.
PRIORITYDOUBLEThe relative importance of the URL amongst all URLs in the same store.
CHANGE_FREQUENCYVARCHAR (3)The frequency of change of the content at a particular URL. Valid options are mapped as follows:
  • A:always
  • H:hourly
  • D:daily
  • W:weekly
  • M:monthly
  • Y:yearly
  • N:never
MOBILE_PRIORITYDOUBLEReserved for HCL internal use.
MOBILE_CHG_FREQVARCHAR (3)Reserved for HCL internal use.
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>SEOURL_IDPrimary Key
I0001429TOKENVALUE+TOKENNAME+SEOURL_IDUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3704SEOURL_IDSEOURLKEYWORDSEOURL_IDCascade