Skip to main content

cloud.oauth_providers

Schema: cloud
English table: cloud.oauth_providers
Italian original table: cloud._oauth_providers
Description: Configuration details for external OAuth2 identity providers.

Overview

  • Columns: 7
  • Primary key: op_provider_id
  • Outgoing foreign keys: 0
  • Incoming foreign keys: 0
  • Indexes: 0

Columns

English columnItalian original columnTypeNullDefault / GeneratedDescription
op_provider_idprov_iduuidNOpublic.uuid_generate_v4()Unique UUID for the provider configuration.
op_nameprov_namecharacter varyingNODisplay name of the provider (e.g., Google, Azure AD).
op_client_idprov_client_idcharacter varyingNOThe public identifier for the OAuth application.
op_client_secretprov_client_secretcharacter varyingNOThe confidential secret key for the OAuth application. Keep encrypted/secure.
op_redirect_urlprov_redirect_urlcharacter varyingNOThe authorized callback URL where the provider sends the auth code.
op_created_atprov_created_attimestamp without time zoneYESCURRENT_TIMESTAMPRecord creation timestamp.
op_updated_atprov_updated_attimestamp without time zoneYESCURRENT_TIMESTAMPLast update timestamp.

Relationships

Outgoing foreign keys

No outgoing foreign keys found.

Referenced by

No incoming foreign keys found.

Constraints

  • Primary key: pk_oauth_providersop_provider_id

Indexes

No indexes detected.