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

Database table TIDMA_PERSONAL_QUESTION

DB attribute	Java data type (max. size), defaults	Description
personal_question_id	Long, not NULL	Primary key that uniquely identifies each individual credential.
client_id	Long, not NULL
content_dict_entry_id	Long, nullable	Links to the personal question's content in other languages. Foreign key that links to information in the table TIDMA_DICT_ENTRY.
description	String(1000), nullable	Defines the semantics of the question.
extid	String(50), not NULL	External ID.
displayname_dict_entry_id	Long, nullable	Links to the personal question's name in other languages. Foreign key that links to information in the table TIDMA_DICT_ENTRY
state_id	Integer, not NULL	Possible states of the personal questions: 2: active; 7: disabled; 9: revoked

Database table TIDMA_PERSONAL_ANSWER

DB attribute	Java data type (max. size), defaults	Description
content	String(4000), not NULL	Symmetrically encrypted answer of user.
credential_id	Long, not NULL	Foreign key that links to information in the table TIDMA_CREDENTIAL.
failure_count	Integer, not NULL	Number of times the security question was answered incorrectly.
personal_answer_id	Long, not NULL	Primary key that uniquely identifies each inividual credential.
personal_question_id	Long, not NULL	Foreign key that links to information in the table TIDMA_PERSONAL_QUESTION.
reveal_count	Integer, not NULL	Number of times the answer has been revealed to an admin.
success_count	Integer, not NULL	Number of times the answer has been verified.