public.sessions

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
session_id	varchar(36)		false
session_type	varchar(50)		false
user_id	varchar(36)		true
device_id	varchar(50)		true
jti	varchar(64)		false
issued_at	timestamp with time zone		false
expires_at	timestamp with time zone		false
ip_address	varchar(45)		true
user_agent	varchar(255)		true
impersonated_by_user_id	varchar(36)		true
revoked_at	timestamp with time zone		true
revoked_reason	varchar(255)		true
created_at	timestamp with time zone		false

Viewpoints

Name	Definition
Authentication & Sessions	User authentication, MFA, sessions, and audit logs

Constraints

Name	Type	Definition
sessions_pkey	PRIMARY KEY	PRIMARY KEY (session_id)

Indexes

Name	Definition
sessions_pkey	CREATE UNIQUE INDEX sessions_pkey ON public.sessions USING btree (session_id)
ix_sessions_device_id	CREATE INDEX ix_sessions_device_id ON public.sessions USING btree (device_id)
ix_sessions_expires_at	CREATE INDEX ix_sessions_expires_at ON public.sessions USING btree (expires_at)
ix_sessions_impersonated_by_user_id	CREATE INDEX ix_sessions_impersonated_by_user_id ON public.sessions USING btree (impersonated_by_user_id)
ix_sessions_jti	CREATE UNIQUE INDEX ix_sessions_jti ON public.sessions USING btree (jti)
ix_sessions_session_type	CREATE INDEX ix_sessions_session_type ON public.sessions USING btree (session_type)
ix_sessions_user_id	CREATE INDEX ix_sessions_user_id ON public.sessions USING btree (user_id)

Relations

---

Generated by tbls