Login information

The TIDMA_CRED_LOGIN_INFO table holds login information of a credential, e.g., the date of the last login and the number of failed logins.

The TIDMA_CRED_LOGIN_INFO table is an extension of the TIDMA_CREDENTIAL base table in All credentials, which lists attributes that are valid for all credentials.

Database table TIDMA_CRED_LOGIN_INFO

DB attribute	Java data type (max. size), defaults	Description
cred_login_info_id	Long, not NULL	Primary key (uniquely identifies each individual DB entry)
credential_id	Long, not NULL	Foreign key that links to information in the table TIDMA_CREDENTIAL.
last_login	Date, nullable	Timestamp of last successful login. NULL means credential has never been used for a successful login.
last_login_failure	Date, nullable	Date of last non-technical login failure, e.g., wrong password. Technical failures (system problems) do not count, neither do login denials because of earlier login problems, e.g., locked account, etc.
login_failure_count	Integer, not NULL	Counts non-technical login failures since the last successful login, initialization or reset (password reset feature or administrator).
login_success_count	Integer, not NULL	Counts successful logins with this credential since last initialization or reset (password reset feature or administrator).