Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 255 | null |
|
|
|||
| event_type | VARCHAR | 50 | null |
|
|
|||
| user_id | VARCHAR | 36 | √ | null |
|
|
||
| user_email | VARCHAR | 255 | √ | null |
|
|
||
| user_registry_id | VARCHAR | 36 | √ | null |
|
|
||
| cognito_pool_id | VARCHAR | 100 | √ | null |
|
|
||
| ip_address | VARCHAR | 45 | √ | null |
|
|
||
| user_agent | VARCHAR | 500 | √ | null |
|
|
||
| success | BIT | 1 | null |
|
|
|||
| tenant_id | VARCHAR | 100 | √ | null |
|
|
||
| failure_reason | VARCHAR | 500 | √ | null |
|
|
||
| mfa_used | BIT | 1 | √ | null |
|
|
||
| mfa_method | VARCHAR | 50 | √ | null |
|
|
||
| event_timestamp | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
|||
| additional_data | JSON | 1073741824 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| fk_auth_audit_log_user_registry | Performance | Asc | user_registry_id |
| idx_auth_audit_log_event_type | Performance | Asc | event_type |
| idx_auth_audit_log_success | Performance | Asc | success |
| idx_auth_audit_log_timestamp | Performance | Asc | event_timestamp |
| idx_auth_audit_log_user_email | Performance | Asc | user_email |
| idx_auth_audit_log_user_id | Performance | Asc | user_id |