role


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uuid uuid 2147483647 gen_random_uuid()
role_permission.role_uuid role_permission_role_uuid_fkey C
role_security_filter.role_uuid role_security_filter_role_uuid_fkey C
user_roles.id_role user_roles_id_role_fkey R
comment text 2147483647 √ null
created_on timestamptz 35,6 now()
props jsonb 2147483647 √ null
tags jsonb 2147483647 √ null
updated_on timestamptz 35,6 now()
version int8 19 1
name text 2147483647 null
roletype text 2147483647 null
id_owned_by uuid 2147483647 null
user.uuid role_id_owned_by_fkey R
id_database uuid 2147483647 null
database_info.uuid role_id_database_fkey C
source text 2147483647 √ null

Table contained 6 rows

Indexes

Constraint Name Type Sort Column(s)
role_pkey Primary key Asc uuid
uk_role Must be unique

Relationships

Close relationships within degrees of separation