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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000185 | NAME | Unique Index |
SQL030416035028310 | PATTRIBUTE_ID | Primary Key |
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 |