SEOPAGEDEFDESC

This table holds the language specific title and meta description for a particular page definition.

Column Descriptions:

NameTypeDescription
SEOPAGEDEF_IDBIGINT NOT NULLThe internal reference number to indicate which SEO page definition ID this language specific information relates to.
LANGUAGE_IDINTEGER NOT NULLThe identifier of the language.
TITLEVARCHAR (254)The language specific page title.
META_DESCVARCHAR (1024)The language specific meta description for the page.
META_KEYWORDVARCHAR (254)The language specific meta keyword for the page.
IMAGE_ALT_DESCVARCHAR (254)The language specific image alternate description for the page.
LASTUPDATETIMESTAMP NOT NULLThe last time the page definition was updated.
CREATEDTIMETIMESTAMP NOT NULLThe time the page definition was created.
FIELD1INTEGERCustomizable field.
FIELD2VARCHAR (254)Customizable field.
FIELD3VARCHAR (254)Customizable field.
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>SEOPAGEDEF_ID+LANGUAGE_IDPrimary Key
I0001411LANGUAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3698SEOPAGEDEF_IDSEOPAGEDEFSEOPAGEDEF_IDCascade
F_3699LANGUAGE_IDLANGUAGELANGUAGE_IDCascade