SEOURL

Token and sitemap information for a particular URL


Column Descriptions:

Name Type Description
SEOURL_ID BIGINT NOT NULL Generated unique key to denote the SEO URL ID.
TOKENNAME VARCHAR (254) NOT NULL The name of the token associated with the URL keyword.
TOKENVALUE VARCHAR (254) NOT NULL The token value for the SEO URL keyword.
PRIORITY DOUBLE The relative importance of the URL amongst all URLs in the same store.
CHANGE_FREQUENCY VARCHAR (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_PRIORITY DOUBLE Reserved for IBM internal use.
MOBILE_CHG_FREQ VARCHAR (3) Reserved for IBM internal use.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> SEOURL_ID Primary Key
I0001429 TOKENVALUE+TOKENNAME+SEOURL_ID Unique Index


Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_3704 SEOURL_ID SEOURLKEYWORD SEOURL_ID Cascade