This table stores information about a gift registry
registrant.
Column Descriptions:
| Name | 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 or wish list to which the
registrant belongs to. |
| RGSTRNTTYPE | INTEGER NOT NULL | The type of user for the gift registry or wish
list. The following types are supported:
- 0: (Default) Indicates registrant.
- 1: Indicates co-registrant (such as a groom for a
wedding).
- 2 to 5: Reserved for IBM internal use.
- 6 : Indicates additional co-registrants, if the gift registry
or wish list is intended to be managed by several people.
|
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| 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 or wish list 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. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | REGISTRANT_ID | Primary Key |
| GRR_CONSTRAINT3 | GIFTREGISTRY_ID+ADDRESS_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| GRR_CONSTRAINT1 | GIFTREGISTRY_ID | GRGFTREG | GIFTREGISTRY_ID | Cascade |