Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GRPURREC
This tables stores purchase record information, regarding items bought from a gift registry list.
Column Name Column Type Description PURCHASERECORD_ID BIGINT NOT NULL Primary key of the table. GIFTREGISTRY_ID BIGINT NOT NULL The gift registry for which this purchase record is made. ADDRESS_ID BIGINT The address of the gift giver. ORDERITEMID BIGINT An item that is in an order. GIFTITEM_ID BIGINT The gift item for the purchase record. CREATETIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP The time when this purchase record was created. UPDATETIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP The time when this purchase record was last updated. PURCHASEDATE DATE NOT NULL The date when the purchase was made. STATUS INTEGER NOT NULL The status of the purchase record.
- 0: Active
- 1: Marked for deletion
ISNOTESENT SMALLINT NOT NULL Indicates whether a thank you note has been sent to the gift giver:
- 0: The note is not sent
- 1: The note is sent
PURCHASEQUANTITY INTEGER NOT NULL Number of items that are bought in this purchase. OPTCOUNTER SMALLINT Reserved for IBM internal use. TRANSACTIONID VARCHAR(32) The transaction ID generated by channels other than Web. REGISTRANTMEMO VARCHAR(254) A note provided by the registrant for this purchase record. PURCHASELOCATION VARCHAR(32) NOT NULL The location where the purchase was made. For example, online, or in store. PARTNUMBER VARCHAR(64) NOT NULL The part number of the gift item. PARTAUXKEY VARCHAR(64) The auxiliary key of the gift item, in case the item can be identified only by two keys.
Indexes Index Name Indexed Column Names Index Type SQL100520030340150 PURCHASERECORD_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type GRP_CONSTRAINT1 ADDRESS_ID GRADDR ADDRESS_ID Cascade PURREC_FK_1 GIFTREGISTRY_ID GRGFTREG GIFTREGISTRY_ID Cascade _vcc_freeselect_bottom_