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

role_scope

Description

Table Definition

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
				)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
roleSlug	VARCHAR(128)		false		role
scopeSlug	VARCHAR(128)		false		scope

Constraints

Name	Type	Definition
roleSlug	PRIMARY KEY	PRIMARY KEY (roleSlug)
scopeSlug	PRIMARY KEY	PRIMARY KEY (scopeSlug)
- (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
sqlite_autoindex_role_scope_1	PRIMARY KEY	PRIMARY KEY (roleSlug, scopeSlug)

Indexes

Name	Definition
IDX_role_scope_scopeSlug	CREATE INDEX "IDX_role_scope_scopeSlug" ON "role_scope" ("scopeSlug")
sqlite_autoindex_role_scope_1	PRIMARY KEY (roleSlug, scopeSlug)

Relations

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" {
  varchar_128_ slug PK
  TEXT displayName
  TEXT description
  TEXT roleType
  boolean systemRole
  datetime_3_ createdAt
  datetime_3_ updatedAt
}
"scope" {
  varchar_128_ slug PK
  TEXT displayName
  TEXT description
}

---

Generated by tbls