Skip to content
Friendly Field NameData Field NameGeneral Data TypeDescriptionOptimised for Searching
UUIDuuidText (length 36)Universally Unique Identifier for each user recordYes
Application UUIDapp_uuidText (length 36)Identifier for the associated applicationYes
Application Context Refapp_context_refText (max length 50)Reference to the application contextYes
UsernameusernameText (max length 100)Username of the userYes
EmailemailText (max length 100)Email address of the userYes
First Namefirst_nameText (max length 50)First name of the userYes
Last Namelast_nameText (max length 50)Last name of the userYes
Mobile Numbermobile_numText (max length 20)Mobile number of the userNo
OTPotpText (max length 100)One-time password for the userNo
Temporary Passwordpassword_tmpText (max length 100)Temporary password for the userNo
Password Hashpassword_hashText (max length 100)Hash of the user’s passwordNo
Password Saltpassword_saltText (max length 40)Salt for the password hashNo
Password Versionpassword_versionNumberVersion number of the passwordNo
Valid Fromvalid_fromDateTimeStart date of the user’s validityNo
Valid Tovalid_toDateTimeEnd date of the user’s validityNo
Is Enabledis_enabledBooleanIndicates whether the user account is enabledNo
Status Codestatus_codeText (max length 10)Code representing the user’s statusNo
Authentication Methodauth_methodEnumerated ListMethod used for user authenticationNo
Authentication Tokenauth_tokenText (max length 255)Authentication token for the userNo
Authentication Token Expiryauth_token_expiryDateTimeExpiry date and time for the authentication tokenNo
2FA2faBitIndicates if two-factor authentication is enabledNo
User Taxonomyuser_taxonomyText (max length 100)Categorisation for the userNo
Created Atcreated_atDateTimeTimestamp when the user record was createdNo
Updated Atupdated_atDateTimeTimestamp when the user record was last updatedNo

This table stores user information for identity services, including authentication and personal details, in a structured and secure manner.