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