Role

Table schema for roles and permission definitions.

Schema reference for role definitions and the permissions attached to them.

Roles Table

Table Name: roles Description: Role definitions and permissions

Schema

Column	Type	Description
_id	string	Role identifier
created_at	timestamp	Creation timestamp
description	string	Role description
frontend_view	string	Frontend view (client or admin)
name	string	Role name
org_id	string	Organization identifier
permission_grants	json	Permission definitions
region_name	string	Deployment region
updated_at	timestamp	Last update timestamp

Query Example

SELECT
  name,
  description,
  frontend_view,
  permission_grants
FROM roles
ORDER BY created_at DESC;