Footprints Data Model

Table
Name pwd_reset_question_answer
Comment
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.

Column
Name Datatype Comment Is PK Is FK
pwd_reset_question_answer_id bigint The automatically generated primary key of the pwd_reset_question_answer table. Yes No
answer varchar(4000) The value of a Password Reset Question Answer, stored as a string. No No
question varchar(255) The value of a Password Reset Question Answer, stored as a string. No No
pwd_reset_regtd_acct_id bigint A Foreign Key to the Password Reset Registered Account table. No Yes