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