Role

Tables for role definitions and permissions.

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
expired_at	timestamp	Expiration timestamp
frontend_view	string	Frontend view (client or admin)
inherited_from	string	Parent role ID
is_base_role	boolean	Base role flag
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,
  is_base_role,
  permission_grants
FROM roles
WHERE expired_at IS NULL OR expired_at > NOW();