auth.mfa_amr_claims
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | session_id | uuid | NO | — | |
| 2 | created_at | timestamp with time zone | NO | — | |
| 3 | updated_at | timestamp with time zone | NO | — | |
| 4 | authentication_method | text | NO | — | |
| 5 | id | uuid | NO | — | PK |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| amr_id_pk | CREATE UNIQUE INDEX amr_id_pk ON auth.mfa_amr_claims USING btree (id) | ✓ | ✓ | 8192 bytes |
| mfa_amr_claims_session_id_authentication_method_pkey | CREATE UNIQUE INDEX mfa_amr_claims_session_id_authentication_method_pkey ON auth.mfa_amr_claims USING btree (session_id, authentication_method) | ✓ | 8192 bytes |
Constraints
| Name | Type | Definition |
|---|---|---|
| mfa_amr_claims_session_id_fkey | FOREIGN KEY | FOREIGN KEY (session_id) REFERENCES auth.sessions(id) ON DELETE CASCADE |
| amr_id_pk | PRIMARY KEY | PRIMARY KEY (id) |
| mfa_amr_claims_session_id_authentication_method_pkey | UNIQUE | UNIQUE (session_id, authentication_method) |