Roles

The roles table contains information on each of the available roles for users in Blocks. In this table you will see the name of each role as well as parent-to-child relationships between roles.

Field	Type	Description	Notes
id	primary key (int)	unique role id	joins: role_id in user table
name	text	name of role	unique to table
description	text	description of role	unique to table
created_at	timestamp	date&time the role was created	unique to table
updated_at	timestamp	date&time the role was last updated	unique to table
parent_id	foreign key (int)	unique id of parent role	joins: role_id in user table
lft/rgt	integer	numerical representation of where the role is in the overall role hierarchy	sort by these columns to see the role tree in hierarchical order
depth	integer	numerical representation of the role level	unique to table
dashboard_layout_id	foreign key (int)	unique id of dashboard	joins id in dashboard_layouts table
admin	text	true/false field	unique to table
needs_training	text	true/false field - if the role can be set up for QC training	unique to table
permissions	jsonb	list of permissions associated with the role	unique to table

No result found