WebSphere Commerce database table: ORDERITEMGIFT

Reference > Database > WebSphere Commerce database tables > O

WebSphere Commerce database table: ORDERITEMGIFT

This table stores the relationship between an order item and a gift registry.

Column Name Column Type Description
ORDERITEMS_ID BIGINT NOT NULL The order item ID.
EXTERNAL_ID VARCHAR(64) NOT NULL The external gift registry ID.
GIFTMESSAGE VARCHAR(4000) A message to accompany the gift (order item), from the gift giver to the gift registrant.
SHIPTORGSTRNT INTEGER Specifies where gifts should be delivered. A value of 1 indicates that gifts should be shipped directly to the gift registrant, using the address provided during gift registry profile creation.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030401240 ORDERITEMS_ID Primary Key
_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column Type	Description
ORDERITEMS_ID	BIGINT NOT NULL	The order item ID.
EXTERNAL_ID	VARCHAR(64) NOT NULL	The external gift registry ID.
GIFTMESSAGE	VARCHAR(4000)	A message to accompany the gift (order item), from the gift giver to the gift registrant.
SHIPTORGSTRNT	INTEGER	Specifies where gifts should be delivered. A value of 1 indicates that gifts should be shipped directly to the gift registrant, using the address provided during gift registry profile creation.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.