This table stores information about a gift registry registrant.

Column Descriptions:

REGISTRANT_IDBIGINT NOT NULLPrimary key of the table.
ADDRESS_IDBIGINT NOT NULLThe address information of the registrant.
GIFTREGISTRY_IDBIGINT NOT NULLThe gift registry or wish list to which the registrant belongs to.
RGSTRNTTYPEINTEGER NOT NULLThe 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 HCL internal use.
  • 6 : Indicates additional co-registrants, if the gift registry or wish list is intended to be managed by several people.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
USERIDVARCHAR (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).
RELATIONVARCHAR (64)The relationship of the registrant or co-registrant of the event. For example, bride or groom for a wedding registry.


NameColumn NamesType

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType