WebSphere Commerce database table: GRUSERAUTH

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

Column Descriptions
Column Name Column Type Description
GIFTREGISTRY_ID BIGINT NOT NULL The gift registry with which this row is associated.
PASSWORD BINARY NOT NULL The password for a user to access the associated gift registry, if password is required.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
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 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
Index Name Indexed Column Names Index Type
SQL060903235203470 GIFTREGISTRY_ID+ACCESSTYPE Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
GRU_CONSTRAINT1 GIFTREGISTRY_ID GRGFTREG GIFTREGISTRY_ID Cascade