SEOREDIRECT

Table to hold information about URL redirection as part of the SEO strategy to handle 404 and 301 redirects.

Column Descriptions:

Name	Type	Description
SEOREDIRECT_ID	BIGINT NOT NULL	This is the primary key.
SEOURLKWD_ID_NEW	BIGINT	Holds the ID of the URL keyword reference that should be redirected to if redirecting to a business object or URL keyword.
SEOURLKWD_ID_ORIG	BIGINT	Holds the ID of the keyword reference that should be redirected from if redirecting from a business object or keyword.
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>	SEOREDIRECT_ID	Primary Key
I0001414	SEOURLKWD_ID_NEW	Non-Unique Index
I0001424	SEOURLKWD_ID_ORIG	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3701	SEOURLKWD_ID_NEW	SEOURLKEYWORD	SEOURLKEYWORD_ID	Cascade
F_3702	SEOURLKWD_ID_ORIG	SEOURLKEYWORD	SEOURLKEYWORD_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3708	SEOREDIRECT_ID	SEOREDIRECTTRAFFIC	SEOREDIRECT_ID	Cascade