os_user_otp_details

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
USER_ID BIGINT 19 null
catissue_user.IDENTIFIER FK_OS_UOTP_USER_IDR
SECRET VARCHAR 255 √ null
RESET_TOKEN VARCHAR 64 √ null
os_auth_tokens.TOKEN Implied ConstraintR
RESET_TOKEN_TIME TIMESTAMP 19 √ null
OTP VARCHAR 16 √ null
OTP_CREATION_TIME TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_OS_UOTP_USER_ID Performance Asc USER_ID

Relationships

Close relationships within degrees of separation