The VCryptUser table contains user details.
This appendix contains a description of the VCryptUser table.
Description: This contains the user details.
Database table name : VCRYPT_USERS
Primary Keys : userId (USER_ID)
Name | DB name | DB type | Java type | Description | Length | Enum value |
---|---|---|---|---|---|---|
userId |
USER_ID (PK) |
BIGINT |
Long |
Id for the User |
16 |
- |
externalUserId |
EXT_USER_ID |
VARCHAR |
String |
User id used by the external system |
255 |
- |
loginId |
LOGIN_ID |
VARCHAR |
String |
Login id of the User |
255 |
- |
groupId |
GROUP_ID |
BIGINT |
Long |
Group Id. |
16 |
- |
acctId |
ACCT_ID |
BIGINT |
Long |
Account Id to which this user belongs to |
16 |
- |
userName |
USER_NAME |
VARCHAR |
String |
Name of the User |
255 |
- |
userEmail |
USER_EMAIL |
VARCHAR |
String |
Email address of the User. |
255 |
- |
password |
PASSWORD |
VARCHAR |
String |
Password for the User |
255 |
- |
pin |
PIN |
VARCHAR |
String |
Password for the User |
255 |
- |
createTime |
CREATE_TIME |
DATETIME |
Date |
Date/Time creation of this user. |
- |
- |
updateTime |
UPDATE_TIME |
TIMESTAMP |
Date |
Date value. |
- |
- |
statusUpdateTime |
STATUS_UPDATE_TIME |
DATETIME |
Date |
Date/Time when the status was updated. |
- |
- |
userType |
USER_TYPE_CODE |
INT |
int |
Type of the User |
2 |
USER_USER |
authMode |
AUTH_MODE_CODE |
INT |
int |
Mode of authorization |
2 |
- |
authType |
AUTH_TYPE_CODE |
INT |
int |
Type of authorization |
2 |
AUTH_TYPE_NORMAL AUTH_TYPE_VCRYPT AUTH_TYPE_PERSONALIZED_VCRYPT |
status |
USER_STATUS_CODE |
INT |
int |
Status of the User |
2 |
STATUS_PENDING_ACTIVATION STATUS_ACTIVE STATUS_DISABLED STATUS_DELETED |
isPinEnabled |
IS_PIN_ENABLED |
CHAR |
boolean |
Whether PIN is enabled for this user |
- |
- |
isADA |
IS_ADA |
CHAR |
boolean |
Is ADA |
- |
- |
isLocked |
IS_LOCKED |
CHAR |
boolean |
Is this user locked. |
- |
- |
lockedTime |
LOCKED_TIME |
DATETIME |
Date |
Date/Time when this user was locked. |
- |
- |
passwordStatus |
PASSWORD_STATUS |
INT |
int |
Status of the password |
2 |
- |
passwordUpdateTime |
PASSWORD_UPDATE_TIME |
DATETIME |
Date |
Date/Time when the password was last updated. |
- |
- |
passwordHistory |
PASSWORD_HISTORY |
TEXT |
String |
List of password which was used by this user. |
4000 |
- |
pinStatus |
PIN_STATUS |
INT |
int |
Status of the pin |
2 |
- |
pinUpdateTime |
PIN_UPDATE_TIME |
DATETIME |
Date |
Date/Time when the pin was last updated. |
- |
- |
pinHistory |
PIN_HISTORY |
TEXT |
String |
List of pin which was used by this user. |
4000 |
- |
imagePath |
IMAGE_PATH |
VARCHAR |
String |
Path to the image file |
255 |
- |
personalNote |
PERSONAL_NOTE |
TEXT |
String |
Personalized note |
4000 |
- |
imageStatus |
IMAGE_STATUS |
INT |
int |
Status of the image |
4 |
- |
phraseStatus |
PHRASE_STATUS |
INT |
int |
Status of the phrase |
4 |
- |
questionStatus |
QUESTION_STATUS |
INT |
int |
Status of the question |
4 |
- |
currentQAId |
CURRENT_QA_ID |
BIGINT |
Long |
The Id of the current question given to the user |
- |
- |
defaultLocaleId |
DEFAULT_LOCALE_ID |
BIGINT |
Long |
Default locale for the user |
16 |
- |
phraseLocaleId |
PHRASE_LOCALE_ID |
BIGINT |
Long |
Locale for the phrase |
16 |
- |
notes |
NOTES |
TEXT |
String |
Note |
4000 |
- |