PATTRIBUTE

This is the personalization attribute supported by the site.

Column Descriptions:

NameTypeDescription
PATTRIBUTE_IDBIGINT NOT NULLThe internal reference number of the Attribute.
NAMEVARCHAR (254) NOT NULLA description of the Attribute. For example, length, width, color, or monogram.
ATTRTYPE_IDCHAR (16) NOT NULLIndicates the data type for this Attribute. For example, integer or string.
ACCESSBEANNAMEVARCHAR (254)Name of the access bean to process this Attribute.
SEQUENCEINTEGERReserved for IBM internal use.
ENCRYPTFLAGINTEGER NOT NULL DEFAULT 0Set to 1 if encryption is required for the personalized attribute value. Default is 0.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PATTRIBUTE_IDPrimary Key
I0000185NAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_566ATTRTYPE_IDATTRTYPEATTRTYPE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_565PATTRIBUTE_IDPATTRDESCPATTRIBUTE_IDCascade
F_567PATTRIBUTE_IDPATTRPRODPATTRIBUTE_IDCascade
F_573PATTRIBUTE_IDPATTRVALUEPATTRIBUTE_IDCascade