Role Scope · SQLite Schema · n8n-io/n8n · Skills Docs

Role Scope · SQLite Schema · n8n-io/n8n · Skills Docs

CREATE TABLE role_scope (
					"roleSlug" VARCHAR(128) NOT NULL,
					"scopeSlug" VARCHAR(128) NOT NULL,
					CONSTRAINT "PK_role_scope" PRIMARY KEY ("roleSlug", "scopeSlug"),
					CONSTRAINT "FK_role" FOREIGN KEY ("roleSlug") REFERENCES role ("slug") ON DELETE CASCADE ON UPDATE CASCADE,
					CONSTRAINT "FK_scope" FOREIGN KEY ("scopeSlug") REFERENCES "scope" ("slug") ON DELETE CASCADE ON UPDATE CASCADE
				)

Name	Type	Definition
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (scopeSlug) REFERENCES scope (slug) ON UPDATE CASCADE ON DELETE CASCADE MATCH NONE
- (Foreign key ID: 1)	FOREIGN KEY	FOREIGN KEY (roleSlug) REFERENCES role (slug) ON UPDATE CASCADE ON DELETE CASCADE MATCH NONE
roleSlug	PRIMARY KEY	PRIMARY KEY (roleSlug)
scopeSlug	PRIMARY KEY	PRIMARY KEY (scopeSlug)
sqlite_autoindex_role_scope_1	PRIMARY KEY	PRIMARY KEY (roleSlug, scopeSlug)

erDiagram

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

"role_scope" {
  VARCHAR_128_ roleSlug PK
  VARCHAR_128_ scopeSlug PK
}
"role" {
  datetime_3_ createdAt
  TEXT description
  TEXT displayName
  TEXT roleType
  varchar_128_ slug PK
  boolean systemRole
  datetime_3_ updatedAt
}
"scope" {
  TEXT description
  TEXT displayName
  varchar_128_ slug PK
}