Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
IDENTIFIER | BIGINT | 19 | √ | null |
|
|
||||||
USER_ID | BIGINT | 19 | null |
|
|
|||||||
IP_ADDRESS | VARCHAR | 32 | null |
|
|
|||||||
LOGIN_TIME | TIMESTAMP | 19 | null |
|
|
|||||||
LOGOUT_TIME | TIMESTAMP | 19 | √ | null |
|
|
||||||
IS_LOGIN_SUCCESSFUL | BIT | 1 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | IDENTIFIER |
FK_LOGIN_AUDIT_LOGS_USER_ID | Performance | Asc | USER_ID |