os_login_audit_logs

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_auth_tokens.LOGIN_AUDIT_LOG_ID FK_AUTH_TOKENS_LA_LOG_IDR
os_user_api_calls_log.LOGIN_AUDIT_LOG_ID FK_API_CALL_LOG_AUDIT_LOG_IDR
USER_ID BIGINT 19 null
catissue_user.IDENTIFIER FK_LOGIN_AUDIT_LOGS_USER_IDR
IP_ADDRESS VARCHAR 32 null
LOGIN_TIME TIMESTAMP 19 null
LOGOUT_TIME TIMESTAMP 19 √ null
IS_LOGIN_SUCCESSFUL BIT 1 null
IMPERSONATED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_LOGIN_AUDIT_IMP_BYR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_LOGIN_AUDIT_IMP_BY Performance Asc IMPERSONATED_BY
FK_LOGIN_AUDIT_LOGS_USER_ID Performance Asc USER_ID

Relationships

Close relationships within degrees of separation