public.authentication_logs
Description
Labels
svc-portal
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| log_id | varchar(36) | false | Log entry identifier (UUID). | |||
| event_type | varchar(50) | false | Auth event type: LOGIN, LOGOUT, MFA_VERIFY, etc. | |||
| success | boolean | false | Event success status. | |||
| user_id | varchar(36) | true | User ID if applicable. | |||
| device_id | varchar(50) | true | Device ID if applicable. | |||
| varchar(255) | true | Email address for login attempts. | ||||
| ip_address | varchar(45) | true | Client IP address. | |||
| user_agent | varchar(255) | true | Client user agent. | |||
| failure_reason | varchar(255) | true | Reason for failure if success=false. | |||
| event_metadata | json | true | Additional event context (JSON). | |||
| impersonated_by_user_id | varchar(36) | true | User ID who initiated impersonation. | |||
| created_at | timestamp with time zone | false | Log entry creation timestamp. |
Viewpoints
| Name | Definition |
|---|---|
| Authentication & Sessions | User authentication, MFA, sessions, and audit logs |
Constraints
| Name | Type | Definition |
|---|---|---|
| authentication_logs_pkey | PRIMARY KEY | PRIMARY KEY (log_id) |
Indexes
| Name | Definition |
|---|---|
| authentication_logs_pkey | CREATE UNIQUE INDEX authentication_logs_pkey ON public.authentication_logs USING btree (log_id) |
| ix_authentication_logs_created_at | CREATE INDEX ix_authentication_logs_created_at ON public.authentication_logs USING btree (created_at) |
| ix_authentication_logs_device_id | CREATE INDEX ix_authentication_logs_device_id ON public.authentication_logs USING btree (device_id) |
| ix_authentication_logs_event_type | CREATE INDEX ix_authentication_logs_event_type ON public.authentication_logs USING btree (event_type) |
| ix_authentication_logs_impersonated_by_user_id | CREATE INDEX ix_authentication_logs_impersonated_by_user_id ON public.authentication_logs USING btree (impersonated_by_user_id) |
| ix_authentication_logs_ip_address | CREATE INDEX ix_authentication_logs_ip_address ON public.authentication_logs USING btree (ip_address) |
| ix_authentication_logs_success | CREATE INDEX ix_authentication_logs_success ON public.authentication_logs USING btree (success) |
| ix_authentication_logs_user_id | CREATE INDEX ix_authentication_logs_user_id ON public.authentication_logs USING btree (user_id) |
Relations
Generated by tbls