Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GRPERATTR
This tables store personalization attributes for gift registry and wish list items, such as monogramming.
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 SQL100520030339880 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 _vcc_freeselect_bottom_