Footprints Data Model

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

Column
Name Datatype Comment Is PK Is FK
app_user_id bigint The automatically generated primary key of the app_user table. Yes No
user_name varchar(255) The name of the Application User. No No
pwd varchar(255) The password, stored only in the case of FootPrints authentication, and only a one-way hash value. No No
cust_login_type_id int A Foreign Key to the Customer Login Type table. For customers, the login type. No Yes
lic_type_id bigint A Foreign Key to the License Type table. The type of Agent licence. No Yes
user_login varchar(255) The user login name that is a unique identifier for the user, regardless of the authentication method. No No
email_addr varchar(255) An email address for the Application User. This is stored here only if it is used for authentication and identification, such as for customer access. No No
delete_date datetime The value of a Application User, stored as a date. No No