This table holds the 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 HCL internal use. |
MOBILE_CHG_FREQ | VARCHAR (3) | Reserved for HCL 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 |