User Password Resets Table Schema (user_password_resets)


table tracking password reset confirmation tokens

user_password_resets table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 null userpassrese_use2_fk R

id of the user account which requester claimed to be

timerequested BIGINT 19 null

The time that the user first requested this password reset

timererequested BIGINT 19 0

The time the user re-requested the password reset.

token VARCHAR 32

secret set and emailed to user

Table contained -1 rows

user_password_resets table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
userpassrese_use_ix Performance Asc userid

user_password_resets table relationships