Connections providers
connections_providers
- Schema: public
- PK:
connection_provider_id (uuid)
Columns
| Column |
Type |
Nullable |
Default |
Notes |
| connection_provider_id |
uuid |
NO |
|
PK |
| provider_name |
varchar |
YES |
|
|
| client_id |
varchar |
YES |
|
OAuth client ID |
| encrypted_client_secret |
varchar |
YES |
|
Encrypted OAuth secret |
| redirect_url |
varchar |
YES |
|
OAuth redirect URI |
| workspace_id |
bigint |
YES |
|
FK to workspaces |
| created_time |
timestamp |
YES |
now() |
|
| last_modified_time |
timestamp |
YES |
now() |
|
| options |
jsonb |
YES |
|
|
| app_type |
varchar |
YES |
|
Integration type slug |
Key indexes
connections_providers_pkey on (connection_provider_id)unique_connection_provider_name_per_workspace UNIQUE on (provider_name, workspace_id)
Notes
- Stores workspace-level OAuth app registrations (BYOA - Bring Your Own App).
- Referenced by
connections.provider_name.