Skip to main content
Version: 7.2405.x.x LTS

Security questions

The tables TIDMA_PERSONAL_QUESTION and TIDMA_PERSONAL_ANSWER hold the attributes available for security questions and answers.

The TIDMA_PERSONAL_QUESTION table defines the available security questions for each client. The TIDMA_PERSONAL_ANSWER table is an extension of the TIDMA_CREDENTIAL, which lists attributes that are valid for all credentials.

Database table TIDMA_PERSONAL_QUESTION

DB attributeJava data type (max. size), defaultsDescription
personal_question_idLong, not NULLPrimary key that uniquely identifies each individual credential.
client_idLong, not NULL
content_dict_entry_idLong, nullableLinks to the personal question's content in other languages. Foreign key that links to information in the table TIDMA_DICT_ENTRY.
descriptionString(1000), nullableDefines the semantics of the question.
extidString(50), not NULLExternal ID.
displayname_dict_entry_idLong, nullableLinks to the personal question's name in other languages. Foreign key that links to information in the table TIDMA_DICT_ENTRY
state_idInteger, not NULLPossible states of the personal questions: 2: active; 7: disabled; 9: revoked

Database table TIDMA_PERSONAL_ANSWER

DB attributeJava data type (max. size), defaultsDescription
contentString(4000), not NULLSymmetrically encrypted answer of user.
credential_idLong, not NULLForeign key that links to information in the table TIDMA_CREDENTIAL.
failure_countInteger, not NULLNumber of times the security question was answered incorrectly.
personal_answer_idLong, not NULLPrimary key that uniquely identifies each inividual credential.
personal_question_idLong, not NULLForeign key that links to information in the table TIDMA_PERSONAL_QUESTION.
reveal_countInteger, not NULLNumber of times the answer has been revealed to an admin.
success_countInteger, not NULLNumber of times the answer has been verified.