CreateOtp creates a new OTP (One-Time Password) record in the database.

CreateUser creates a new user in the database with the given email.

CreateVerification creates a new verification record in the database.

DestroyAccount deletes a user account from the database based on the provided ID.

GetNewOtps retrieves a list of new OTPs from the database based on the provided OTP code.

GetUserDetail retrieves the user details from the database based on the provided email.

InsertPasswordHistory inserts a new password history record into the database.

JoinUsersWithVerificationByEmail joins the user table with the verification table based on the provided email.

JoinUsersWithVerificationByPhone retrieves a list of users along with their verification information based on the provided phone number.

JoinUsersWithVerificationByUsername joins the user table with the verification table based on the provided username.

UpdateOnlyPassword updates the password hash for a user in the database.

UpdateOtpIsActive updates the isActive status of an OTP code in the database.

UpdateVerification updates the verification status and activity status of a user in the database.