WebSphere Commerce database table: GRGFTREG

This table stores gift registry profile information.

Column Descriptions
Column Name Column Type Description
GIFTREGISTRY_ID BIGINT NOT NULL Reserved for IBM internal use.
EVENTTYPE_ID INTEGER NOT NULL The event type for this gift registry.
GUESTACCESSOPTION INTEGER NOT NULL DEFAULT 0 Specifies guess access options for the gift registry. Valid values are as follows:

  • 0: The gift registry is public. It can be searched or viewed by anyone.

  • 1: The gift registry can not be searched but is not password protected.

  • 2: The gift registry is password protected, but searchable.

PREEVENTADDRESS_ID BIGINT NOT NULL The pre-event shipping address of this gift registry.
POSTEVENTADDRESS_ID BIGINT NOT NULL The post-event shipping address of this gift registry.
STATUS INTEGER NOT NULL Status of this gift registry. Valid values are as follows:

  • 0: The gift registry is not active (that is, it is disabled). Only the merchant can activate the registry.

  • 1: The gift registry is active.

  • 2. The gift registry is completed.

  • 3: The gift registry has expired.

  • 4: The gift registry is marked for deletion.

ACCEPTGIFTCARD INTEGER NOT NULL Specifies whether gift cards can be accepted as gifts. Two values are available:

  • 0: Gift cards are not accepted

  • 1: Gift cards are accepted

STOREID INTEGER NOT NULL The identifier of the store for the gift registry.
OPTFOREMAIL INTEGER NOT NULL Specifies whether the registrant wants to receive e-mail notifications. Two values are available:

  • 0: The registrant does not want to receive e-mail.

  • 1: The registrant wants to receive e-mail.

REGTYPE INTEGER NOT NULL DEFAULT 0 The type of registry. Default is 0.
FIELD1 INTEGER Customizable.
FIELD2 INTEGER Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
CREATEDTIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP The time when this gift registry was created.
LASTUPDATE TIMESTAMP NOT NULL The time when the gift registry was last updated.
EVENTDATE DATE NOT NULL The date for event (or purpose of this gift registry).
LOCATION VARCHAR(32) NOT NULL The location for which this gift registry is created.
EXTERNALID VARCHAR(64) NOT NULL This externalId is used to uniquely identify a gift registry.
DESCRIPTION VARCHAR(64) This description can be used to store longer descriptions. It can be displayed as a part of a search result.
MESSAGEFORGUEST VARCHAR(512) The message that will be displayed to the guests who view this gift registry.
NAME VARCHAR(16) The name of the gift registry.
GUESTACCESSKEY VARCHAR(64) A random number that uniquely identifies a gift registry. This access key can be used to allow a guest to view the registry.
REGACCESSKEY VARCHAR(64) A random number that uniquely identifies a gift registry. This access key can be used to allow a registrant to add product directly to the registry from e-mail.
FIELD3 VARCHAR(64) Customizable.
FIELD4 VARCHAR(64) Customizable.
FIELD5 VARCHAR(64) Customizable.

Indexes
Index Name Indexed Column Names Index Type
GR_INDEX1 EXTERNALID Unique Index
GR_INDEX2 POSTEVENTADDRESS_ID Unique Index
GR_INDEX3 PREEVENTADDRESS_ID Unique Index
SQL060903235202760 GIFTREGISTRY_ID Primary Key
GRG_CONSTRAINT1 STOREID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
GRG_CONSTRAINT2 PREEVENTADDRESS_ID GRADDR ADDRESS_ID Cascade
GRG_CONSTRAINT4 POSTEVENTADDRESS_ID GRADDR ADDRESS_ID Cascade
GR_FK_2 EVENTTYPE_ID GREVNTTYPE EVENTTYPE_ID No Action

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
ANN_CONST2 GIFTREGISTRY_ID GRANNHIST GIFTREGISTRY_ID No Action
GRE_CONSTRAINT2 GIFTREGISTRY_ID GREVTRMDLG GIFTREGISTRY_ID No Action
GIFTITEM_FK_1 GIFTREGISTRY_ID GRGFTITM GIFTREGISTRY_ID Cascade
PURREC_FK_1 GIFTREGISTRY_ID GRPURREC GIFTREGISTRY_ID Cascade
GRR_CONSTRAINT1 GIFTREGISTRY_ID GRRGSTRNT GIFTREGISTRY_ID Cascade
GRU_CONSTRAINT1 GIFTREGISTRY_ID GRUSERAUTH GIFTREGISTRY_ID Cascade