public.sessions

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
session_id	varchar(36)		false			Session identifier (UUID).
session_type	varchar(50)		false			Session type: USER or DEVICE.
user_id	varchar(36)		true			User ID for USER sessions.
device_id	varchar(50)		true			Device ID for DEVICE sessions.
jti	varchar(64)		false			JWT ID unique identifier.
issued_at	timestamp with time zone		false			Token issued timestamp.
expires_at	timestamp with time zone		false			Token expiration timestamp.
ip_address	varchar(45)		true			Client IP address.
user_agent	varchar(255)		true			Client user agent.
impersonated_by_user_id	varchar(36)		true			User ID who initiated impersonation.
revoked_at	timestamp with time zone		true			Session revocation timestamp.
revoked_reason	varchar(255)		true			Reason for revocation.
created_at	timestamp with time zone		false			Record creation timestamp.

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