| GIFTREGISTRY_ID | BIGINT NOT NULL | Reserved for IBM internal use. The surrogate
primary key of this table. This ID should not be exposed to
external users. |
| EVENTTYPE_ID | INTEGER NOT NULL | The event type for this gift registry and wish
list. |
| GUESTACCESSOPTION | INTEGER NOT NULL DEFAULT 0 | Specifies guest access options for the gift
registry and wish list. Valid values are as follows:
- 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 as follows:
- 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| 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 created or deleted. |
| EVENTDATE | DATE NOT NULL | The date for event (or purpose of this gift
registry or wish list). |
| 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. |