WebSphere Commerce database table: ORDERITEMGIFT

WebSphere Commerce database table: ORDERITEMGIFT

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

Column Descriptions
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

SQL060903235219700 ORDERITEMS_ID Primary Key

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.