public.authentication_logs

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
log_id	varchar(36)		false
event_type	varchar(50)		false
success	boolean		false
user_id	varchar(36)		true
device_id	varchar(50)		true
email	varchar(255)		true
ip_address	varchar(45)		true
user_agent	varchar(255)		true
failure_reason	varchar(255)		true
event_metadata	json		true
impersonated_by_user_id	varchar(36)		true
created_at	timestamp with time zone		false

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