WebSphere Commerce database table: PATTRIBUTE

This is the personalization attribute supported by the site.

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
I0000185 NAME Unique Index
SQL060903235225910 PATTRIBUTE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_566 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names 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