n8n/docs/generated/postgres-schema/public.role.md

public.role

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
slug	varchar(128)		false	public.user public.project_relation public.role_scope public.role_mapping_rule		Unique identifier of the role for example: "global:owner"
displayName	text		true			Name used to display in the UI
description	text		true			Text describing the scope in more detail of users
roleType	text		true			Type of the role, e.g., global, project, or workflow
systemRole	boolean	false	false			Indicates if the role is managed by the system and cannot be edited
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
role_createdAt_not_null	n	NOT NULL "createdAt"
role_slug_not_null	n	NOT NULL slug
role_systemRole_not_null	n	NOT NULL "systemRole"
role_updatedAt_not_null	n	NOT NULL "updatedAt"
PK_35c9b140caaf6da09cfabb0d675	PRIMARY KEY	PRIMARY KEY (slug)

Indexes

Name	Definition
PK_35c9b140caaf6da09cfabb0d675	CREATE UNIQUE INDEX "PK_35c9b140caaf6da09cfabb0d675" ON public.role USING btree (slug)
IDX_UniqueRoleDisplayName	CREATE UNIQUE INDEX "IDX_UniqueRoleDisplayName" ON public.role USING btree ("displayName")

Relations

erDiagram

"public.user" }o--|| "public.role" : "FOREIGN KEY (#quot;roleSlug#quot;) REFERENCES role(slug)"
"public.project_relation" }o--|| "public.role" : "FOREIGN KEY (role) REFERENCES role(slug)"
"public.role_scope" }o--|| "public.role" : "FOREIGN KEY (#quot;roleSlug#quot;) REFERENCES role(slug) ON UPDATE CASCADE ON DELETE CASCADE"
"public.role_mapping_rule" }o--|| "public.role" : "FOREIGN KEY (role) REFERENCES role(slug) ON UPDATE CASCADE ON DELETE CASCADE"

"public.role" {
  varchar_128_ slug
  text displayName
  text description
  text roleType
  boolean systemRole
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
}
"public.user" {
  uuid id
  varchar_255_ email
  varchar_32_ firstName
  varchar_32_ lastName
  varchar_255_ password
  json personalizationAnswers
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
  json settings
  boolean disabled
  boolean mfaEnabled
  text mfaSecret
  text mfaRecoveryCodes
  date lastActiveAt
  varchar_128_ roleSlug FK
}
"public.project_relation" {
  varchar_36_ projectId FK
  uuid userId FK
  varchar role FK
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
}
"public.role_scope" {
  varchar_128_ roleSlug FK
  varchar_128_ scopeSlug FK
}
"public.role_mapping_rule" {
  varchar_16_ id
  text expression
  varchar_128_ role FK
  varchar_64_ type
  integer order
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
}

---

Generated by tbls