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
depth	integer	numerical representation of the role level	unique to 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	ㅤ

No result found