mirror of
https://github.com/n8n-io/n8n.git
synced 2026-07-27 19:15:01 +02:00
75 lines
2.2 KiB
Markdown
75 lines
2.2 KiB
Markdown
# role_scope
|
|
|
|
## Description
|
|
|
|
<details>
|
|
<summary><strong>Table Definition</strong></summary>
|
|
|
|
```sql
|
|
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
|
|
)
|
|
```
|
|
|
|
</details>
|
|
|
|
## Columns
|
|
|
|
| Name | Type | Default | Nullable | Children | Parents | Comment |
|
|
| ---- | ---- | ------- | -------- | -------- | ------- | ------- |
|
|
| roleSlug | VARCHAR(128) | | false | | [role](role.md) | |
|
|
| scopeSlug | VARCHAR(128) | | false | | [scope](scope.md) | |
|
|
|
|
## Constraints
|
|
|
|
| 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) |
|
|
|
|
## 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
|
|
|
|
```mermaid
|
|
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
|
|
}
|
|
```
|
|
|
|
---
|
|
|
|
> Generated by [tbls](https://github.com/k1LoW/tbls)
|