mirror of
https://github.com/n8n-io/n8n.git
synced 2026-07-29 20:15:00 +02:00
1.2 KiB
1.2 KiB
public.scope
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| slug | varchar(128) | false | public.role_scope | Unique identifier of the scope for example: "project:create" | ||
| displayName | text | true | Name used to display in the UI | |||
| description | text | true | Text describing the scope in more detail of users |
Constraints
| Name | Type | Definition |
|---|---|---|
| scope_slug_not_null | n | NOT NULL slug |
| PK_bfc45df0481abd7f355d6187da1 | PRIMARY KEY | PRIMARY KEY (slug) |
Indexes
| Name | Definition |
|---|---|
| PK_bfc45df0481abd7f355d6187da1 | CREATE UNIQUE INDEX "PK_bfc45df0481abd7f355d6187da1" ON public.scope USING btree (slug) |
Relations
erDiagram
"public.role_scope" }o--|| "public.scope" : "FOREIGN KEY (#quot;scopeSlug#quot;) REFERENCES scope(slug) ON UPDATE CASCADE ON DELETE CASCADE"
"public.scope" {
varchar_128_ slug
text displayName
text description
}
"public.role_scope" {
varchar_128_ roleSlug FK
varchar_128_ scopeSlug FK
}
Generated by tbls