Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GRGFTITM
This tables stores information about a gift registry and wish list item.
Column Name Column Type Description GIFTITEM_ID BIGINT NOT NULL Primary key of the table. GIFTREGISTRY_ID BIGINT NOT NULL Indicates to which gift registry or wish list this item belongs. QUANTITYREQUESTED INTEGER NOT NULL Desired quantity of this item. QUANTITYBOUGHT INTEGER NOT NULL DEFAULT 0 Quantity of this item purchased by a gift giver. FIELD1 INTEGER Customizable. FIELD2 INTEGER Customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use. CREATETIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP Date this item was added to the registry list or wish list. LASTUPDATE TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP Date this item was updated. LOCATION VARCHAR(32) NOT NULL The location from where this item was added. PARTNUMBER VARCHAR(64) NOT NULL The part number (SKU) of the item. PARTAUXKEY VARCHAR(64) NOT NULL DEFAULT '' Optional key of the gift item. This key is in place in case an item can be identified only by compound keys. For example, a catalog entry in WebSphere Commerce is uniquely identified by the memberId plus the partNumber. FIELD3 VARCHAR(64) Customizable. FIELD4 VARCHAR(64) Customizable. FIELD5 VARCHAR(64) Customizable.
Indexes Index Name Indexed Column Names Index Type GIFTITEM_UINDEX1 GIFTREGISTRY_ID+PARTNUMBER+PARTAUXKEY Unique Index SQL100520030339600 GIFTITEM_ID Primary Key GIFTITEM_INDEX2 GIFTREGISTRY_ID+PARTNUMBER Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type GIFTITEM_FK_1 GIFTREGISTRY_ID GRGFTREG GIFTREGISTRY_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type GRA_CONSTRAINT4 GIFTITEM_ID GRPERATTR GIFTITEM_ID Cascade _vcc_freeselect_bottom_