auth.saml_providers
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | — | PK |
| 2 | sso_provider_id | uuid | NO | — | |
| 3 | entity_id | text | NO | — | |
| 4 | metadata_xml | text | NO | — | |
| 5 | metadata_url | text | YES | — | |
| 6 | attribute_mapping | jsonb | YES | — | |
| 7 | created_at | timestamp with time zone | YES | — | |
| 8 | updated_at | timestamp with time zone | YES | — | |
| 9 | name_id_format | text | YES | — |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| saml_providers_entity_id_key | CREATE UNIQUE INDEX saml_providers_entity_id_key ON auth.saml_providers USING btree (entity_id) | ✓ | 8192 bytes | |
| saml_providers_pkey | CREATE UNIQUE INDEX saml_providers_pkey ON auth.saml_providers USING btree (id) | ✓ | ✓ | 8192 bytes |
| saml_providers_sso_provider_id_idx | CREATE INDEX saml_providers_sso_provider_id_idx ON auth.saml_providers USING btree (sso_provider_id) | 8192 bytes |
Constraints
| Name | Type | Definition |
|---|---|---|
| entity_id not empty | CHECK | CHECK ((char_length(entity_id) > 0)) |
| metadata_url not empty | CHECK | CHECK (((metadata_url = NULL::text) OR (char_length(metadata_url) > 0))) |
| metadata_xml not empty | CHECK | CHECK ((char_length(metadata_xml) > 0)) |
| saml_providers_sso_provider_id_fkey | FOREIGN KEY | FOREIGN KEY (sso_provider_id) REFERENCES auth.sso_providers(id) ON DELETE CASCADE |
| saml_providers_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| saml_providers_entity_id_key | UNIQUE | UNIQUE (entity_id) |