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

variables

Description

Table Definition

CREATE TABLE "variables" ("id" varchar(36) PRIMARY KEY NOT NULL, "key" text NOT NULL, "type" text NOT NULL DEFAULT ('string'), "value" text, "projectId" varchar(36), CONSTRAINT "FK_a0f13eaa709a21b77a3a9721319" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	varchar(36)		false
key	TEXT		false
type	TEXT	'string'	false
value	TEXT		true
projectId	varchar(36)		true		project

Constraints

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

Indexes

Name	Definition
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")
sqlite_autoindex_variables_1	PRIMARY KEY (id)

Relations

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
  TEXT type
  TEXT value
  varchar_36_ projectId FK
}
"project" {
  varchar_36_ id PK
  varchar_255_ name
  varchar_36_ type
  datetime_3_ createdAt
  datetime_3_ updatedAt
  TEXT icon
  varchar_512_ description
  varchar creatorId FK
  TEXT customTelemetryTags
}

---

Generated by tbls