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