Footprints Data Model |
Table |
Table Name | Password Reset Question Answer |
Table Definition | This table holds the users' answers to the system questions set by the administrators and the Id to the actual question. Users can answer questions even after the administrator has disabled them, as long as they were available when the user first registered the answer. |
Attribute |
Attribute Name | Attribute Definition | Logical Datatype | Is Required |
Password Reset Question Answer Id | The automatically generated primary key of the pwd_reset_question_answer table. | LONG | Yes |
Answer | The value of a Password Reset Question Answer, stored as a string. | VARCHAR(4000) | Yes |
Question | The value of a Password Reset Question Answer, stored as a string. | VARCHAR(255) | Yes |
Password Reset Registered Account Id | A Foreign Key to the Password Reset Registered Account table. | LONG | No |