auth.saml_relay_states
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | — | PK |
| 2 | sso_provider_id | uuid | NO | — | |
| 3 | request_id | text | NO | — | |
| 4 | for_email | text | YES | — | |
| 5 | redirect_to | text | YES | — | |
| 7 | created_at | timestamp with time zone | YES | — | |
| 8 | updated_at | timestamp with time zone | YES | — | |
| 9 | flow_state_id | uuid | YES | — |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| saml_relay_states_created_at_idx | CREATE INDEX saml_relay_states_created_at_idx ON auth.saml_relay_states USING btree (created_at DESC) | 8192 bytes | ||
| saml_relay_states_for_email_idx | CREATE INDEX saml_relay_states_for_email_idx ON auth.saml_relay_states USING btree (for_email) | 8192 bytes | ||
| saml_relay_states_pkey | CREATE UNIQUE INDEX saml_relay_states_pkey ON auth.saml_relay_states USING btree (id) | ✓ | ✓ | 8192 bytes |
| saml_relay_states_sso_provider_id_idx | CREATE INDEX saml_relay_states_sso_provider_id_idx ON auth.saml_relay_states USING btree (sso_provider_id) | 8192 bytes |
Constraints
| Name | Type | Definition |
|---|---|---|
| request_id not empty | CHECK | CHECK ((char_length(request_id) > 0)) |
| saml_relay_states_flow_state_id_fkey | FOREIGN KEY | FOREIGN KEY (flow_state_id) REFERENCES auth.flow_state(id) ON DELETE CASCADE |
| saml_relay_states_sso_provider_id_fkey | FOREIGN KEY | FOREIGN KEY (sso_provider_id) REFERENCES auth.sso_providers(id) ON DELETE CASCADE |
| saml_relay_states_pkey | PRIMARY KEY | PRIMARY KEY (id) |