This table holds the store and language specific
SEO URL keyword information
Column Descriptions:
| Name | Type | Description |
| SEOURLKEYWORD_ID | BIGINT NOT NULL | Generated unique key to denote the SEO URL
keyword ID. |
| SEOURL_ID | BIGINT NOT NULL | The internal reference number that indicates
which SEO URL this language specific information relates to. |
| LANGUAGE_ID | INTEGER NOT NULL | The identifier of the language. |
| STOREENT_ID | INTEGER NOT NULL | The reference number of the store entity the URL
keyword belongs to. |
| URLKEYWORD | VARCHAR (254) NOT NULL | The SEO URL keyword. |
| MOBILEURLKEYWORD | VARCHAR (254) | Reserved for IBM internal use. |
| STATUS | INTEGER NOT NULL DEFAULT 1 | The status of the URL keyword.
- 0 - INACTIVE
- 1 - ACTIVE
- 2 - EXPIRED
|
| 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> | SEOURLKEYWORD_ID | Primary Key |
| I0001417 | URLKEYWORD+STOREENT_ID | Unique Index |
| I0001420 | SEOURL_ID | Non-Unique Index |
| I0001421 | STOREENT_ID | Non-Unique Index |
| I0001430 | LANGUAGE_ID | Non-Unique Index |
| I0001433 | MOBILEURLKEYWORD+STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3704 | SEOURL_ID | SEOURL | SEOURL_ID | Cascade |
| F_3705 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
| F_3706 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3701 | SEOURLKEYWORD_ID | SEOREDIRECT | SEOURLKWD_ID_NEW | Cascade |
| F_3702 | SEOURLKEYWORD_ID | SEOREDIRECT | SEOURLKWD_ID_ORIG | Cascade |