WebSphere Commerce database table: GRGFTREG

Reference > Database > WebSphere Commerce database tables > G

WebSphere Commerce database table: GRGFTREG

This table stores gift registry and wish list profile information.

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 and wish list.
GUESTACCESSOPTION INTEGER NOT NULL DEFAULT 0 Specifies guess access options for the gift registry and wish list. Valid values are...

0: The gift registry is public. It can be searched or viewed by anyone. This is the default column value for a gift registry.

1: The gift registry can not be searched but is not password protected. This is the default column value for a wish list.

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

PREEVENTADDRESS_ID BIGINT NOT NULL The pre-event shipping address of this gift registry. Column value 0 is used to indicate the address is not available.
POSTEVENTADDRESS_ID BIGINT NOT NULL The post-event shipping address of this gift registry. Column value 0 is used to indicate the address is not available.
STATUS INTEGER NOT NULL Status of this gift registry or wish list. Valid values are...

0: Indicates inactive state (that is, it is disabled). Only the merchant can activate the registry.

1: Indicates active state.

2. Indicates completed state.

3: Indicates expired state.

4: Indicates marked for deletion.

5: Indicates default wish list. This status is not applicable for gift registry.

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 or wish list.
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 or wish list. Default is 0 for gift registry and 1 for wish list.
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 or wish list was created.
LASTUPDATE TIMESTAMP NOT NULL The time when the gift registry or wish list was last updated.
EVENTDATE DATE NOT NULL The date for event.
LOCATION VARCHAR(32) NOT NULL The location from where this gift registry or wish list is created.
EXTERNALID VARCHAR(64) NOT NULL This externalId is used to uniquely identify a gift registry or wish list.
DESCRIPTION VARCHAR(254) 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 or wish list.
NAME VARCHAR(64) The name of the gift registry or wish list.
GUESTACCESSKEY VARCHAR(64) A randomly generated number that can be used as an access key to allow a guest to view the registry or wish list ignoring guest access option and password protection.
REGACCESSKEY VARCHAR(64) A randomly generated number that can be used as an access key to allow a registrant to add products directly to the registry or wish list from e-mail by ignoring the manage access password.
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
SQL100520030339740 GIFTREGISTRY_ID Primary Key
GRG_CONSTRAINT1 STOREID Non-Unique Index
GR_INDEX2 POSTEVENTADDRESS_ID Non-Unique Index
GR_INDEX3 PREEVENTADDRESS_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
GR_FK_2 EVENTTYPE_ID GREVNTTYPE EVENTTYPE_ID No Action

Referenced By
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
_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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 and wish list.
GUESTACCESSOPTION	INTEGER NOT NULL DEFAULT 0	Specifies guess access options for the gift registry and wish list. Valid values are... 0: The gift registry is public. It can be searched or viewed by anyone. This is the default column value for a gift registry. 1: The gift registry can not be searched but is not password protected. This is the default column value for a wish list. 2: The gift registry is password protected, but searchable.
PREEVENTADDRESS_ID	BIGINT NOT NULL	The pre-event shipping address of this gift registry. Column value 0 is used to indicate the address is not available.
POSTEVENTADDRESS_ID	BIGINT NOT NULL	The post-event shipping address of this gift registry. Column value 0 is used to indicate the address is not available.
STATUS	INTEGER NOT NULL	Status of this gift registry or wish list. Valid values are... 0: Indicates inactive state (that is, it is disabled). Only the merchant can activate the registry. 1: Indicates active state. 2. Indicates completed state. 3: Indicates expired state. 4: Indicates marked for deletion. 5: Indicates default wish list. This status is not applicable for gift registry.
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 or wish list.
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 or wish list. Default is 0 for gift registry and 1 for wish list.
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 or wish list was created.
LASTUPDATE	TIMESTAMP NOT NULL	The time when the gift registry or wish list was last updated.
EVENTDATE	DATE NOT NULL	The date for event.
LOCATION	VARCHAR(32) NOT NULL	The location from where this gift registry or wish list is created.
EXTERNALID	VARCHAR(64) NOT NULL	This externalId is used to uniquely identify a gift registry or wish list.
DESCRIPTION	VARCHAR(254)	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 or wish list.
NAME	VARCHAR(64)	The name of the gift registry or wish list.
GUESTACCESSKEY	VARCHAR(64)	A randomly generated number that can be used as an access key to allow a guest to view the registry or wish list ignoring guest access option and password protection.
REGACCESSKEY	VARCHAR(64)	A randomly generated number that can be used as an access key to allow a registrant to add products directly to the registry or wish list from e-mail by ignoring the manage access password.
FIELD3	VARCHAR(64)	Customizable.
FIELD4	VARCHAR(64)	Customizable.
FIELD5	VARCHAR(64)	Customizable.

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

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