GRPURREC

This tables stores purchase record information, regarding items bought from a gift registry list.

Column Descriptions:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
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:

Name	Column Names	Type
<SYSTEM-GENERATED>	PURCHASERECORD_ID	Primary Key

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
GRP_CONSTRAINT1	ADDRESS_ID	GRADDR	ADDRESS_ID	Cascade
PURREC_FK_1	GIFTREGISTRY_ID	GRGFTREG	GIFTREGISTRY_ID	Cascade