Database Table: PATTRIBUTE

This is the personalization Attribute supported by the site.

Column Name Column Type Column Description
ACCESSBEANNAME VARCHAR (254)
NULL
Name of the access bean to process this Attribute.
ATTRTYPE_ID CHARACTER (16)
NOT NULL
Indicates the data type for this Attribute. For example, integer or string.
ENCRYPTFLAG INTEGER
NOT NULL, DEFAULT 0
Set to 1 if encryption is required for the personalized attribute value. Default is 0.
NAME VARCHAR (254)
NOT NULL
A description of the Attribute. For example, length, width, color, or monogram.
PATTRIBUTE_ID BIGINT
NOT NULL
The internal reference number of the Attribute.
SEQUENCE INTEGER
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000185 NAME Unique Index
SQL030416035028310 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