public.mfa_codes

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
code_id	varchar(36)		false
user_id	varchar(36)		false
code_type	varchar(50)		false
code_hash	varchar(255)		false
sent_to	varchar(255)		false
sent_at	timestamp with time zone		false
expires_at	timestamp with time zone		false
is_used	boolean		false
used_at	timestamp with time zone		true
verification_attempts	integer		false
created_at	timestamp with time zone		false

Viewpoints

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

Constraints

Name	Type	Definition
mfa_codes_pkey	PRIMARY KEY	PRIMARY KEY (code_id)

Indexes

Name	Definition
mfa_codes_pkey	CREATE UNIQUE INDEX mfa_codes_pkey ON public.mfa_codes USING btree (code_id)
ix_mfa_codes_expires_at	CREATE INDEX ix_mfa_codes_expires_at ON public.mfa_codes USING btree (expires_at)
ix_mfa_codes_user_id	CREATE INDEX ix_mfa_codes_user_id ON public.mfa_codes USING btree (user_id)

Relations

---

Generated by tbls