WebSphere Commerce database table: GRPERATTR

WebSphere Commerce database table: GRPERATTR

This tables store personalization attributes for gift registry items, such as monogramming.
Column Descriptions
Column Name Column Type Description
PERATTR_ID VARCHAR(64) NOT NULL Refers to a monogramming attribute or other attributes.
GIFTITEM_ID BIGINT NOT NULL Refers to the item requiring personalization.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
VALUE VARCHAR(64) The value of the attribute. It is up to the user of this value to interpret its type and meaning.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235202900 GIFTITEM_ID+PERATTR_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
GRA_CONSTRAINT4 GIFTITEM_ID GRGFTITM GIFTITEM_ID Cascade

Column Name	Column Type	Description
PERATTR_ID	VARCHAR(64) NOT NULL	Refers to a monogramming attribute or other attributes.
GIFTITEM_ID	BIGINT NOT NULL	Refers to the item requiring personalization.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.
VALUE	VARCHAR(64)	The value of the attribute. It is up to the user of this value to interpret its type and meaning.