K VCryptUser Table

The VCryptUser table contains user details.

This appendix contains a description of the VCryptUser table.

K.1 VCryptUser

Description: This contains the user details.

Database table name : VCRYPT_USERS

Primary Keys : userId (USER_ID)

Table K-1 VCryptUser

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

-