Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: 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 Name Column 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 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 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 Index Name Indexed Column Names Index Type SQL100520030340560 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 _vcc_freeselect_bottom_