mfa_type for a user is only being set into the mfa_secrets table, never updated into the users table. Even at the time of a non-first time auth, the flow remains the same -> get user_id from the auth interceptor's caught metadata (the user context keys) -> get the mfa_type from the mfa_secrets table associated with the same user_id.
Now, either keep the design same, that is reading two tables for different parameters or start updating the users table as well.
mfa_typefor a user is only being set into themfa_secretstable, never updated into theuserstable. Even at the time of a non-first time auth, the flow remains the same -> getuser_idfrom the auth interceptor's caught metadata (the user context keys) -> get themfa_typefrom themfa_secretstable associated with the sameuser_id.Now, either keep the design same, that is reading two tables for different parameters or start updating the
userstable as well.