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 |