SEOREDIRECT

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

Column Descriptions:

NameTypeDescription
SEOREDIRECT_IDBIGINT NOT NULLThis is the primary key.
SEOURLKWD_ID_NEWBIGINTHolds the ID of the URL keyword reference that should be redirected to if redirecting to a business object or URL keyword.
SEOURLKWD_ID_ORIGBIGINTHolds the ID of the keyword reference that should be redirected from if redirecting from a business object or keyword.
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>SEOREDIRECT_IDPrimary Key
I0001414SEOURLKWD_ID_NEWNon-Unique Index
I0001424SEOURLKWD_ID_ORIGNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3701SEOURLKWD_ID_NEWSEOURLKEYWORDSEOURLKEYWORD_IDCascade
F_3702SEOURLKWD_ID_ORIGSEOURLKEYWORDSEOURLKEYWORD_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3708SEOREDIRECT_IDSEOREDIRECTTRAFFICSEOREDIRECT_IDCascade