This table stores information about a gift registry registrant.
Column Descriptions
| Column Name
| Column Type
| Description |
| REGISTRANT_ID
| BIGINT NOT NULL
| Primary key of the table.
|
| ADDRESS_ID
| BIGINT NOT NULL
| The address information of the registrant.
|
| GIFTREGISTRY_ID
| BIGINT NOT NULL
| The gift registry for which this reminder is logged.
|
| RGSTRNTTYPE
| INTEGER NOT NULL
| The type of user for the gift registry. The following types are supported:
- 0: (Default) Indicates gift registry registrant.
- 1: Indicates gift registry co-registrant (such as a groom for a wedding).
- 2 to 5: Reserved for IBM internal use.
- 6 or above: Indicates additional co-registrants, if the gift registry is intended to be managed by several people.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
| USERID
| VARCHAR(32)
| User ID of the registrant, if a registrant is a registered user. This field is unique for a given registry (that is, a registry cannot be associated with the same registrant more than once).
|
| RELATION
| VARCHAR(64)
| The relationship of the registrant or co-registrant of the event. For example, bride or groom for a wedding registry.
|