Database – Customer Login Attempts (customer_login_attempts)
This holds the login attempts into the customer portal. It serves as an audit trail of account access.
|
Column |
Data Type |
Column Info |
Value Notes |
Other |
|
id |
int(11) |
The id of the entity |
||
|
customer_id |
int(11) |
ID for the customer |
||
|
attempt_time |
timestamp |
Timestamp of login attempt |
||
|
ip_address |
text |
IP address of remote client |
||
|
client_info |
text |
Information about the web browser used |
||
|
was_successful |
tinyint(1) |
Indicates whether or not the attempt resulted in access to the portal |
1 - yes, 0 - no |
|
|
lastUpdated |
timestamp |
|
||
|
username_used |
text |
Username used for the attempt |