n8n/docs/generated/postgres-schema/public.secrets_provider_connection.md

public.secrets_provider_connection

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
encryptedSettings	text		false
id	integer		false	public.project_secrets_provider_access
isEnabled	boolean	false	false
providerKey	varchar(128)		false
type	varchar(36)		false			Type of secrets provider. Possible values: awsSecretsManager, gcpSecretsManager, vault, azureKeyVault, infisical
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
PK_4350ae85e76f9ba7df1370acb5d	PRIMARY KEY	PRIMARY KEY (id)
secrets_provider_connection_createdAt_not_null	n	NOT NULL "createdAt"
secrets_provider_connection_encryptedSettings_not_null	n	NOT NULL "encryptedSettings"
secrets_provider_connection_id_not_null	n	NOT NULL id
secrets_provider_connection_isEnabled_not_null	n	NOT NULL "isEnabled"
secrets_provider_connection_providerKey_not_null	n	NOT NULL "providerKey"
secrets_provider_connection_type_not_null	n	NOT NULL type
secrets_provider_connection_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_secrets_provider_connection_providerKey	CREATE UNIQUE INDEX "IDX_secrets_provider_connection_providerKey" ON public.secrets_provider_connection USING btree ("providerKey")
PK_4350ae85e76f9ba7df1370acb5d	CREATE UNIQUE INDEX "PK_4350ae85e76f9ba7df1370acb5d" ON public.secrets_provider_connection USING btree (id)

Relations

erDiagram

"public.project_secrets_provider_access" }o--|| "public.secrets_provider_connection" : "FOREIGN KEY (#quot;secretsProviderConnectionId#quot;) REFERENCES secrets_provider_connection(id) ON DELETE CASCADE"

"public.secrets_provider_connection" {
  timestamp_3__with_time_zone createdAt
  text encryptedSettings
  integer id
  boolean isEnabled
  varchar_128_ providerKey
  varchar_36_ type
  timestamp_3__with_time_zone updatedAt
}
"public.project_secrets_provider_access" {
  timestamp_3__with_time_zone createdAt
  varchar_36_ projectId FK
  varchar_128_ role
  integer secretsProviderConnectionId FK
  timestamp_3__with_time_zone updatedAt
}

---

Generated by tbls