GRGFTITM

This tables stores information about a gift registry and wish list item.

Column Descriptions:

NameTypeDescription
GIFTITEM_IDBIGINT NOT NULLPrimary key of the table.
GIFTREGISTRY_IDBIGINT NOT NULLIndicates to which gift registry or wish list this item belongs.
QUANTITYREQUESTEDINTEGER NOT NULLDesired quantity of this item.
QUANTITYBOUGHTINTEGER NOT NULL DEFAULT 0Quantity of this item purchased by a gift giver.
FIELD1INTEGERCustomizable.
FIELD2INTEGERCustomizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
CREATETIMETIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMPDate this item was added to the registry list or wish list.
LASTUPDATETIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMPDate this item was updated.
LOCATIONVARCHAR (32) NOT NULLThe location from where this item was added.
PARTNUMBERVARCHAR (64) NOT NULLThe part number (SKU) of the item.
PARTAUXKEYVARCHAR (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 HCL Commerce is uniquely identified by the memberId plus the partNumber.
FIELD3VARCHAR (64)Customizable.
FIELD4VARCHAR (64)Customizable.
FIELD5VARCHAR (64)Customizable.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>GIFTITEM_IDPrimary Key
GIFTITEM_UINDEX1GIFTREGISTRY_ID+PARTNUMBER+PARTAUXKEYUnique Index
GIFTITEM_INDEX2GIFTREGISTRY_ID+PARTNUMBERNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
GIFTITEM_FK_1GIFTREGISTRY_IDGRGFTREGGIFTREGISTRY_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
GRA_CONSTRAINT4GIFTITEM_IDGRPERATTRGIFTITEM_IDCascade