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 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. |