PATTRDESC

Reserved for IBM internal use.


Column Descriptions:

Name Type Description
PATTRIBUTE_ID BIGINT NOT NULL The identifier of the personalization attribute.
LANGUAGE_ID INTEGER NOT NULL Language this description pertains to. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR (1024) A brief description of the personalization attribute.
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> PATTRIBUTE_ID+LANGUAGE_ID Primary Key


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_564 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_565 PATTRIBUTE_ID PATTRIBUTE PATTRIBUTE_ID Cascade