Subject Area : 190 - Password Reset |
Subject Area Name | Definition | |||||
---|---|---|---|---|---|---|
190 - Password Reset | Tables to support self help Password Reset functionality. | |||||
ER Diagram Name | Physical Display Level | |||||
Logical | Column | |||||
Physical | Column | |||||
Physical Name | Entity/Table Name | Logical Only | Do Not Generate | Definition | ||
app_user | Application User | false | A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
pwd | Password | This space intentionally left blank. | varchar(255) | |||
user_name | User Name | The name of the Application User. | nvarchar(4000) | |||
cust_login_type_id | Customer Login Type Id | A Foreign Key to the Customer Login Type table. | int | |||
app_user_id | Application User Id | The automatically generated primary key of the app_user table. | bigint | |||
lic_type_id | License Type Id | A Foreign Key to the License Type table. | bigint | |||
user_login | User Login | The login name used to access the Application. This may not be filled in if external application security is used. | nvarchar(4000) | |||
email_addr | Email Address | An email address for the Application User. | nvarchar(4000) | |||
delete_date | Delete Date | The value of a Application User, stored as a date. | datetime | |||
pwd_reset_question | Password Reset Question | false | Questions, once they've been saved, can only be disabled (deactivated). Users who have already used those questions as part of their password reset registration will still be able to use the disabled questions. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
pwd_reset_question_id | Password Reset Question Id | The automatically generated primary key of the pwd_reset_question table. | bigint | |||
question | Question | The value of a Password Reset Question, stored as a string. | varchar(255) | |||
pwd_reset_question_answer | Password Reset Question Answer | false |
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. |
|||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
pwd_reset_question_answer_id | Password Reset Question Answer Id | The automatically generated primary key of the pwd_reset_question_answer table. | bigint | |||
answer | Answer | The value of a Password Reset Question Answer, stored as a string. | nvarchar(max) | |||
question | Question | The value of a Password Reset Question Answer, stored as a string. | varchar(255) | |||
pwd_reset_regtd_acct_id | Password Reset Registered Account Id | The automatically generated primary key of the pwd_reset_regtd_acct table. | bigint | |||
pwd_reset_regtd_acct | Password Reset Registered Account | false | This holds LDAP information. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
pwd_reset_regtd_acct_name | Password Reset Registered Account Name | This is the registered user name. | nvarchar(4000) | |||
display_name | Display Name | This is the name pulled back from the active directory service. | varchar(255) | |||
distinguished_name | Distinguished Name | The name of the Password Reset Registered Account. | varchar(255) | |||
failed_reset_ct | Failed Reset Count | Count of failed resets. | int | |||
failed_reset_timestamp | Failed Reset Timestamp | Last time of failed reset. | datetime | |||
regtd_email | Registered Email | Email registered to handle reset verification. | varchar(255) | |||
app_user_id | Application User Id |
A Foreign Key to the Application User table. The application user id will be used to tie AD accounts to existing Footprints customers. If the user comes in anonymously through the browse feature, this field will be null. |
bigint | |||
pwd_reset_regtd_acct_id | Password Reset Registered Account Id | The automatically generated primary key of the pwd_reset_regtd_acct table. | bigint |