Footprints Data Model

Table
Table Name Application User
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Application User Id The automatically generated primary key of the app_user table. LONG Yes
User Name The name of the Application User. VARCHAR(255) No
User Login The login name used to access the Application. This may not be filled in if external application security is used. VARCHAR(255) Yes
Password This space intentionally left blank. VARCHAR(255) No
Delete Date The value of a Application User, stored as a date. DATE No
Email Address An email address for the Application User. VARCHAR(255) No