WebSphere Commerce database table: PATTRIBUTE

This is the personalization attribute supported by the site.


Column Description(s):
Column NameColumn TypeDescription
PATTRIBUTE_ID BIGINT NOT NULL The internal reference number of the Attribute.
NAME VARCHAR(254) NOT NULL A description of the Attribute. For example, length, width, color, or monogram.
ATTRTYPE_ID CHAR(16) NOT NULL Indicates the data type for this Attribute. For example, integer or string.
ACCESSBEANNAME VARCHAR(254) Name of the access bean to process this Attribute.
SEQUENCE INTEGER Reserved for IBM internal use.
ENCRYPTFLAG INTEGER NOT NULL DEFAULT 0 Set to 1 if encryption is required for the personalized attribute value. Default is 0.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000185 NAME Unique Index
SQL050212031253150 PATTRIBUTE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_566 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_565 PATTRIBUTE_ID PATTRDESC PATTRIBUTE_ID Cascade
F_567 PATTRIBUTE_ID PATTRPROD PATTRIBUTE_ID Cascade
F_573 PATTRIBUTE_ID PATTRVALUE PATTRIBUTE_ID Cascade

Feedback