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


How did we do?


Powered by HelpDocs (opens in a new tab)