SEOPAGEDEFDESC

Language specific title and meta description for a particular page definition.


Column Descriptions:

Name Type Description
SEOPAGEDEF_ID BIGINT NOT NULL The internal reference number to indicate which SEO page definition ID this language specific information relates to.
LANGUAGE_ID INTEGER NOT NULL The identifier of the language.
TITLE VARCHAR (254) The language specific page title.
META_DESC VARCHAR (1024) The language specific meta description for the page.
META_KEYWORD VARCHAR (254) The language specific meta keyword for the page.
IMAGE_ALT_DESC VARCHAR (254) The language specific image alternate description for the page.
LASTUPDATE TIMESTAMP NOT NULL The last time the page definition was updated.
CREATEDTIME TIMESTAMP NOT NULL The time the page definition was created.
FIELD1 INTEGER Customizable field.
FIELD2 VARCHAR (254) Customizable field.
FIELD3 VARCHAR (254) Customizable field.
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> SEOPAGEDEF_ID+LANGUAGE_ID Primary Key
I0001411 LANGUAGE_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_3698 SEOPAGEDEF_ID SEOPAGEDEF SEOPAGEDEF_ID Cascade
F_3699 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade