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