auth.mfa_challenges
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | — | PK |
| 2 | factor_id | uuid | NO | — | |
| 3 | created_at | timestamp with time zone | NO | — | |
| 4 | verified_at | timestamp with time zone | YES | — | |
| 5 | ip_address | inet | NO | — |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| mfa_challenge_created_at_idx | CREATE INDEX mfa_challenge_created_at_idx ON auth.mfa_challenges USING btree (created_at DESC) | 8192 bytes | ||
| mfa_challenges_pkey | CREATE UNIQUE INDEX mfa_challenges_pkey ON auth.mfa_challenges USING btree (id) | ✓ | ✓ | 8192 bytes |
Constraints
| Name | Type | Definition |
|---|---|---|
| mfa_challenges_auth_factor_id_fkey | FOREIGN KEY | FOREIGN KEY (factor_id) REFERENCES auth.mfa_factors(id) ON DELETE CASCADE |
| mfa_challenges_pkey | PRIMARY KEY | PRIMARY KEY (id) |