User Password History Table Schema (user_password_history)


Description

A rotating log of hashes of previously used passwords for each user.

user_password_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 null
user.id userpasshist_use2_fk R
hash VARCHAR 255
timecreated BIGINT 19 null

Table contained -1 rows

user_password_history table indexes

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

user_password_history table relationships

Close relationships within degrees of separation