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

scope

Description

Table Definition

CREATE TABLE "scope" ("slug" varchar(128) PRIMARY KEY NOT NULL, "displayName" text, "description" text)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
slug	varchar(128)		false	role_scope
displayName	TEXT		true
description	TEXT		true

Constraints

Name	Type	Definition
slug	PRIMARY KEY	PRIMARY KEY (slug)
sqlite_autoindex_scope_1	PRIMARY KEY	PRIMARY KEY (slug)

Indexes

Name	Definition
sqlite_autoindex_scope_1	PRIMARY KEY (slug)

Relations

erDiagram

"role_scope" |o--|| "scope" : "FOREIGN KEY (scopeSlug) REFERENCES scope (slug) ON UPDATE CASCADE ON DELETE CASCADE MATCH NONE"

"scope" {
  varchar_128_ slug PK
  TEXT displayName
  TEXT description
}
"role_scope" {
  VARCHAR_128_ roleSlug PK
  VARCHAR_128_ scopeSlug PK
}

---

Generated by tbls