public.mfa_codes
Description
Labels
svc-portal
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| code_id | varchar(36) | false | MFA code identifier (UUID). | |||
| user_id | varchar(36) | false | User ID who owns this code. | |||
| code_type | varchar(50) | false | Code type: LOGIN or PASSWORD_RESET. | |||
| code_hash | varchar(255) | false | Hash of the MFA code. | |||
| sent_to | varchar(255) | false | Destination phone or email. | |||
| sent_at | timestamp with time zone | false | Code sent timestamp. | |||
| expires_at | timestamp with time zone | false | Code expiration timestamp. | |||
| is_used | boolean | false | Code used flag. | |||
| used_at | timestamp with time zone | true | Code verified timestamp. | |||
| verification_attempts | integer | false | Number of verification attempts. | |||
| 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 |
|---|---|---|
| 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