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_


+

Search Tips   |   Advanced Search