This tables stores information about a gift registry item.
Column Descriptions
| 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 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.
|
| 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.
|