WebSphere Commerce database table: PATTRDESC

WebSphere Commerce database table: PATTRDESC

Reserved for IBM internal use.
Column Descriptions
Column Name Column 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 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235225760 PATTRIBUTE_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_564 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_565 PATTRIBUTE_ID PATTRIBUTE PATTRIBUTE_ID Cascade

Column Name	Column 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	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_564	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_565	PATTRIBUTE_ID	PATTRIBUTE	PATTRIBUTE_ID	Cascade