Footprints Data Model

Table
Name pwd_reset_regtd_acct
Comment This holds LDAP information.

Column
Name Datatype Comment Is PK Is FK
pwd_reset_regtd_acct_id bigint The automatically generated primary key of the pwd_reset_regtd_acct table. Yes No
pwd_reset_regtd_acct_name varchar(255) The name of the Password Reset Registered Account. No No
display_name varchar(255) The name of the Password Reset Registered Account. No No
distinguished_name varchar(255) The name of the Password Reset Registered Account. No No
failed_reset_ct int Count of failed resets. No No
failed_reset_timestamp datetime Last time of failed reset. No No
regtd_email varchar(255) Email registered to handle reset verification. No No
app_user_id bigint 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. No Yes