Skip to content

public.role

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false public.group Unique identifier of the role.(DC2Type:uuid)
name varchar(255) false Unique name of the role (e.g., ROLE_ADMIN, ROLE_USER). Used for permission checks and authorization.
keycloak_id uuid true External Keycloak role identifier for SSO integration. Null if role is not synced with Keycloak.(DC2Type:uuid)

Constraints

Name Type Definition
role_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
role_pkey CREATE UNIQUE INDEX role_pkey ON public.role USING btree (id)
uniq_57698a6a5e237e06 CREATE UNIQUE INDEX uniq_57698a6a5e237e06 ON public.role USING btree (name)

Relations

er

Generated by tbls