Variables · SQLite Schema · n8n-io/n8n · Skills Docs

Skill 16 · SQLite Schema

Subchapter 16.156

Variables

variables.mdMarkdown2 KBView on GitHub

Description

Name	Type	Definition
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_variables_1	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
sqlite_autoindex_variables_1	PRIMARY KEY (id)
variables_global_key_unique	CREATE UNIQUE INDEX “variables_global_key_unique” ON “variables” (“key”) WHERE projectId IS NULL
variables_project_key_unique	CREATE UNIQUE INDEX “variables_project_key_unique” ON “variables” (“projectId”, “key”)

erDiagram

"variables" }o--o| "project" : "FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"variables" {
  varchar_36_ id PK
  TEXT key
  varchar_36_ projectId FK
  TEXT type
  TEXT value
}
"project" {
  datetime_3_ createdAt
  varchar creatorId FK
  TEXT customTelemetryTags
  varchar_512_ description
  TEXT icon
  varchar_36_ id PK
  varchar_255_ name
  varchar_36_ type
  datetime_3_ updatedAt
}