GRUSERAUTH

This table authenticates a user's access to view or edit a gift registry or wish list. A gift registrant or co-registrant can view and change gift registry or wish list information. A gift giver can view a gift registry or wish list.

Column Descriptions:

Name	Type	Description
GIFTREGISTRY_ID	BIGINT NOT NULL	The gift registry or wish list with which this row is associated.
PASSWORD	BINARY NOT NULL	The password for a user to access the associated gift registry or wish list, if password is required.
OPTCOUNTER	SMALLINT	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
ACCESSTYPE	INTEGER NOT NULL	The type of user. The following types are supported: 1: Registrant, or co-registrant (if applicable) 2: Gift giver
STATUS	INTEGER NOT NULL DEFAULT 1	The access status of the user. Two options are supported: 0: The user's access to the gift registry or wish list is revoked 1: The user's access is active
PASSWORDCREATION	TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP	The creation time of the password.
SALT	VARCHAR (254) NOT NULL	The salt used to cipher and decipher the password.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	GIFTREGISTRY_ID+ACCESSTYPE	Primary Key

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
GRU_CONSTRAINT1	GIFTREGISTRY_ID	GRGFTREG	GIFTREGISTRY_ID	Cascade