Understand the Database Schema for User and Permissions
masterThe backend uses five primary tables to manage users, roles, and permissions:
user: Stores user information.role: Stores role information.user_role: Maps users to roles (One-to-One relationship).permission: Defines the resources and operations (e.g.,user:list) that can be accessed.role_permission: Maps roles to permissions (One-to-Many relationship).
Note on Super Admins: The ROLE_ADMIN role may not have explicit permission entries in the role_permission table. Instead, the system is designed to return all permissions automatically when this role is identified, granting full access without needing exhaustive database records.