Database – Customer Login Attempts (customer_login_attempts)
Description
This table holds the login attempts into the customer portal, serving 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 | Timestamp of when it was last updated | ||
username_used | text | Username used for the attempt |