User Account Management Hierarchy

This document visualizes the User Account Management hierarchy in SMAP based on the database schema and recent migrations.

Entity Relations & Architecture

The user and role management system uses a flattened, self-referencing structure:

• Organization: There is no separate standalone organizations table. Instead, organizations are managed within the users table via the organization_id column, which acts as a self-referencing foreign key to a parent user record.
• Roles: Enforced via an enum column (role) in the users table. Supported roles are:
  • superadmin: Has ultimate control over the system.
  • organization_admin: Administrator of a specific organization context.
  • organization_client: A standard user or client belonging to an organization.
• Groups: Scoped to an Organization (organization_id). They are defined in the groups table.
• User-Group Mapping: Users are assigned to Groups through a many-to-many mapping table named users_groups.

Mermaid Diagram

Flow: Superadmin Onboards New Client & Assigns Accounts

This flow illustrates how a Superadmin sets up a brand new organization client, including setting up their context, groups, and assigning social media accounts to those groups.

Flow: Organization Admin Adds Group & Client

This flow illustrates how an existing Organization Admin manages their own context by creating a new group, adding a new client, and assigning social media accounts to that group.