Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PATTRIBUTE
This is the personalization attribute supported by the site.
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 SQL100520030407460 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
Referenced By 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
Related reference
_vcc_freeselect_bottom_