auth.sso_domains
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | — | PK |
| 2 | sso_provider_id | uuid | NO | — | |
| 3 | domain | text | NO | — | |
| 4 | created_at | timestamp with time zone | YES | — | |
| 5 | updated_at | timestamp with time zone | YES | — |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| sso_domains_domain_idx | CREATE UNIQUE INDEX sso_domains_domain_idx ON auth.sso_domains USING btree (lower(domain)) | ✓ | 8192 bytes | |
| sso_domains_pkey | CREATE UNIQUE INDEX sso_domains_pkey ON auth.sso_domains USING btree (id) | ✓ | ✓ | 8192 bytes |
| sso_domains_sso_provider_id_idx | CREATE INDEX sso_domains_sso_provider_id_idx ON auth.sso_domains USING btree (sso_provider_id) | 8192 bytes |
Constraints
| Name | Type | Definition |
|---|---|---|
| domain not empty | CHECK | CHECK ((char_length(domain) > 0)) |
| sso_domains_sso_provider_id_fkey | FOREIGN KEY | FOREIGN KEY (sso_provider_id) REFERENCES auth.sso_providers(id) ON DELETE CASCADE |
| sso_domains_pkey | PRIMARY KEY | PRIMARY KEY (id) |