n8n/docs/generated/sqlite-schema/secrets_provider_connection.md

secrets_provider_connection

Description

Table Definition

CREATE TABLE "secrets_provider_connection" ("id" integer PRIMARY KEY NOT NULL, "providerKey" varchar(128) NOT NULL, "type" varchar(36) NOT NULL, "encryptedSettings" text NOT NULL, "isEnabled" boolean NOT NULL DEFAULT (false), "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')))

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	INTEGER		false	project_secrets_provider_access
providerKey	varchar(128)		false
type	varchar(36)		false
encryptedSettings	TEXT		false
isEnabled	boolean	false	false
createdAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false
updatedAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false

Constraints

Name	Type	Definition
id	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
IDX_secrets_provider_connection_providerKey	CREATE UNIQUE INDEX "IDX_secrets_provider_connection_providerKey" ON "secrets_provider_connection" ("providerKey")

Relations

erDiagram

"project_secrets_provider_access" |o--|| "secrets_provider_connection" : "FOREIGN KEY (secretsProviderConnectionId) REFERENCES secrets_provider_connection (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"secrets_provider_connection" {
  INTEGER id
  varchar_128_ providerKey
  varchar_36_ type
  TEXT encryptedSettings
  boolean isEnabled
  datetime_3_ createdAt
  datetime_3_ updatedAt
}
"project_secrets_provider_access" {
  INTEGER secretsProviderConnectionId PK
  varchar_36_ projectId PK
  datetime_3_ createdAt
  datetime_3_ updatedAt
  varchar_128_ role
}

---

Generated by tbls